Name Game
You can find the complete source code for this model here.
The Data set consists of name, gender, state and year with the number of people that were born with that name in that gender, state and year.
query: table('bigquery-public-data.usa_names.usa_1910_2013') -> { top: 10 project: * }
| state | gender | year | name | number |
|---|---|---|---|---|
| AK | F | 1,910 | Elsie | 6 |
| AL | F | 1,910 | Annie | 482 |
| AL | F | 1,910 | Katie | 84 |
| AL | F | 1,910 | Alma | 82 |
| AL | F | 1,910 | Thelma | 65 |
| AL | F | 1,910 | Ellen | 38 |
| AL | F | 1,910 | Rebecca | 35 |
| AL | F | 1,910 | Estella | 21 |
| AL | F | 1,910 | Corine | 17 |
| AL | F | 1,910 | Margie | 17 |
[ { "state": "AK", "gender": "F", "year": 1910, "name": "Elsie", "number": 6 }, { "state": "AL", "gender": "F", "year": 1910, "name": "Annie", "number": 482 }, { "state": "AL", "gender": "F", "year": 1910, "name": "Katie", "number": 84 }, { "state": "AL", "gender": "F", "year": 1910, "name": "Alma", "number": 82 }, { "state": "AL", "gender": "F", "year": 1910, "name": "Thelma", "number": 65 }, { "state": "AL", "gender": "F", "year": 1910, "name": "Ellen", "number": 38 }, { "state": "AL", "gender": "F", "year": 1910, "name": "Rebecca", "number": 35 }, { "state": "AL", "gender": "F", "year": 1910, "name": "Estella", "number": 21 }, { "state": "AL", "gender": "F", "year": 1910, "name": "Corine", "number": 17 }, { "state": "AL", "gender": "F", "year": 1910, "name": "Margie", "number": 17 } ]
SELECT base.state as state, base.gender as gender, base.year as year, base.name as name, base.number as number FROM `bigquery-public-data.usa_names.usa_1910_2013` as base LIMIT 10
The command above says query the table 'bigquery-public-data.usa_names.usa_1910_2013' and project (show)
all the columns for the first 10 rows.
Grouping a query
In SQL there are basically two kinds of SELECT commands: SELECT ... GROUP BY and SELECT without a grouping.
In Malloy, these are two different commands. The command in Malloy for SELECT ... GROUP BY is group_by. Since number
and year are reserved words, we have to quote the names with back-tics.
query: table('bigquery-public-data.usa_names.usa_1910_2013') -> { group_by: name aggregate: population is `number`.sum() }
| name | population |
|---|---|
| James | 4,942,431 |
| John | 4,834,422 |
| Robert | 4,718,787 |
| Michael | 4,297,230 |
| William | 3,822,209 |
| Mary | 3,737,679 |
| David | 3,549,801 |
| Richard | 2,531,924 |
| Joseph | 2,472,917 |
| Charles | 2,244,693 |
| Thomas | 2,212,781 |
| Christopher | 1,987,490 |
| Daniel | 1,842,964 |
| Patricia | 1,569,570 |
| Matthew | 1,538,689 |
| Elizabeth | 1,492,404 |
| Jennifer | 1,463,145 |
| Linda | 1,447,601 |
| Barbara | 1,424,203 |
| Donald | 1,402,666 |
| Anthony | 1,385,453 |
| Paul | 1,355,711 |
| Mark | 1,339,371 |
| George | 1,321,652 |
| Steven | 1,269,627 |
| Kenneth | 1,259,720 |
| Andrew | 1,228,080 |
| Edward | 1,210,315 |
| Joshua | 1,163,481 |
| Brian | 1,156,495 |
| Kevin | 1,148,680 |
| Margaret | 1,120,766 |
| Susan | 1,108,712 |
| Ronald | 1,074,141 |
| Timothy | 1,055,792 |
| Dorothy | 1,052,570 |
| Jessica | 1,038,359 |
| Jason | 1,009,416 |
| Sarah | 1,006,934 |
| Betty | 985,364 |
| Nancy | 984,185 |
| Karen | 982,192 |
| Jeffrey | 969,093 |
| Lisa | 962,981 |
| Ryan | 907,969 |
| Gary | 896,637 |
| Helen | 895,428 |
| Sandra | 870,958 |
| Nicholas | 867,231 |
| Eric | 862,204 |
| Jacob | 848,518 |
| Stephen | 844,930 |
| Ashley | 841,427 |
| Donna | 826,714 |
| Kimberly | 826,275 |
| Frank | 818,197 |
| Carol | 817,290 |
| Jonathan | 803,723 |
| Michelle | 803,162 |
| Larry | 801,398 |
| Emily | 779,755 |
| Amanda | 769,292 |
| Scott | 765,844 |
| Justin | 757,273 |
| Laura | 745,892 |
| Melissa | 745,498 |
| Raymond | 744,284 |
| Deborah | 735,869 |
| Brandon | 735,849 |
| Stephanie | 732,651 |
| Rebecca | 728,799 |
| Ruth | 728,678 |
| Anna | 719,803 |
| Sharon | 718,701 |
| Kathleen | 703,265 |
| Cynthia | 703,175 |
| Gregory | 701,504 |
| Shirley | 686,079 |
| Samuel | 681,358 |
| Amy | 673,234 |
| Benjamin | 664,328 |
| Patrick | 655,434 |
| Angela | 653,663 |
| Jack | 634,113 |
| Virginia | 621,448 |
| Jerry | 618,105 |
| Dennis | 610,894 |
| Catherine | 606,029 |
| Brenda | 604,067 |
| Alexander | 598,944 |
| Katherine | 593,220 |
| Pamela | 591,307 |
| Nicole | 576,870 |
| Tyler | 576,031 |
| Christine | 574,120 |
| Henry | 571,539 |
| Walter | 558,026 |
| Peter | 553,789 |
| Douglas | 552,666 |
| Janet | 550,557 |
[ { "name": "James", "population": 4942431 }, { "name": "John", "population": 4834422 }, { "name": "Robert", "population": 4718787 }, { "name": "Michael", "population": 4297230 }, { "name": "William", "population": 3822209 }, { "name": "Mary", "population": 3737679 }, { "name": "David", "population": 3549801 }, { "name": "Richard", "population": 2531924 }, { "name": "Joseph", "population": 2472917 }, { "name": "Charles", "population": 2244693 }, { "name": "Thomas", "population": 2212781 }, { "name": "Christopher", "population": 1987490 }, { "name": "Daniel", "population": 1842964 }, { "name": "Patricia", "population": 1569570 }, { "name": "Matthew", "population": 1538689 }, { "name": "Elizabeth", "population": 1492404 }, { "name": "Jennifer", "population": 1463145 }, { "name": "Linda", "population": 1447601 }, { "name": "Barbara", "population": 1424203 }, { "name": "Donald", "population": 1402666 }, { "name": "Anthony", "population": 1385453 }, { "name": "Paul", "population": 1355711 }, { "name": "Mark", "population": 1339371 }, { "name": "George", "population": 1321652 }, { "name": "Steven", "population": 1269627 }, { "name": "Kenneth", "population": 1259720 }, { "name": "Andrew", "population": 1228080 }, { "name": "Edward", "population": 1210315 }, { "name": "Joshua", "population": 1163481 }, { "name": "Brian", "population": 1156495 }, { "name": "Kevin", "population": 1148680 }, { "name": "Margaret", "population": 1120766 }, { "name": "Susan", "population": 1108712 }, { "name": "Ronald", "population": 1074141 }, { "name": "Timothy", "population": 1055792 }, { "name": "Dorothy", "population": 1052570 }, { "name": "Jessica", "population": 1038359 }, { "name": "Jason", "population": 1009416 }, { "name": "Sarah", "population": 1006934 }, { "name": "Betty", "population": 985364 }, { "name": "Nancy", "population": 984185 }, { "name": "Karen", "population": 982192 }, { "name": "Jeffrey", "population": 969093 }, { "name": "Lisa", "population": 962981 }, { "name": "Ryan", "population": 907969 }, { "name": "Gary", "population": 896637 }, { "name": "Helen", "population": 895428 }, { "name": "Sandra", "population": 870958 }, { "name": "Nicholas", "population": 867231 }, { "name": "Eric", "population": 862204 }, { "name": "Jacob", "population": 848518 }, { "name": "Stephen", "population": 844930 }, { "name": "Ashley", "population": 841427 }, { "name": "Donna", "population": 826714 }, { "name": "Kimberly", "population": 826275 }, { "name": "Frank", "population": 818197 }, { "name": "Carol", "population": 817290 }, { "name": "Jonathan", "population": 803723 }, { "name": "Michelle", "population": 803162 }, { "name": "Larry", "population": 801398 }, { "name": "Emily", "population": 779755 }, { "name": "Amanda", "population": 769292 }, { "name": "Scott", "population": 765844 }, { "name": "Justin", "population": 757273 }, { "name": "Laura", "population": 745892 }, { "name": "Melissa", "population": 745498 }, { "name": "Raymond", "population": 744284 }, { "name": "Deborah", "population": 735869 }, { "name": "Brandon", "population": 735849 }, { "name": "Stephanie", "population": 732651 }, { "name": "Rebecca", "population": 728799 }, { "name": "Ruth", "population": 728678 }, { "name": "Anna", "population": 719803 }, { "name": "Sharon", "population": 718701 }, { "name": "Kathleen", "population": 703265 }, { "name": "Cynthia", "population": 703175 }, { "name": "Gregory", "population": 701504 }, { "name": "Shirley", "population": 686079 }, { "name": "Samuel", "population": 681358 }, { "name": "Amy", "population": 673234 }, { "name": "Benjamin", "population": 664328 }, { "name": "Patrick", "population": 655434 }, { "name": "Angela", "population": 653663 }, { "name": "Jack", "population": 634113 }, { "name": "Virginia", "population": 621448 }, { "name": "Jerry", "population": 618105 }, { "name": "Dennis", "population": 610894 }, { "name": "Catherine", "population": 606029 }, { "name": "Brenda", "population": 604067 }, { "name": "Alexander", "population": 598944 }, { "name": "Katherine", "population": 593220 }, { "name": "Pamela", "population": 591307 }, { "name": "Nicole", "population": 576870 }, { "name": "Tyler", "population": 576031 }, { "name": "Christine", "population": 574120 }, { "name": "Henry", "population": 571539 }, { "name": "Walter", "population": 558026 }, { "name": "Peter", "population": 553789 }, { "name": "Douglas", "population": 552666 }, { "name": "Janet", "population": 550557 } ]
SELECT base.name as name, COALESCE(SUM(base.number),0) as population FROM `bigquery-public-data.usa_names.usa_1910_2013` as base GROUP BY 1 ORDER BY 2 desc
Malloy compiles to SQL. The SQL query for the above command is.
SELECT base.name as name, SUM(base.number) as population FROM `bigquery-public-data.usa_names.usa_1910_2013` as base GROUP BY 1 ORDER BY 2 desc
Expressions
Expressions work much the same as they do in SQL. We can look at population over decade by using a calculation against the year.
query: table('bigquery-public-data.usa_names.usa_1910_2013') -> { top: 10 group_by: decade is floor(`year` / 10) * 10 aggregate: population is sum(`number`) }
| decade | population |
|---|---|
| 1,950 | 37,545,138 |
| 1,960 | 35,405,002 |
| 1,990 | 33,309,594 |
| 2,000 | 33,041,629 |
| 1,980 | 32,349,146 |
| 1,970 | 29,238,092 |
| 1,940 | 27,776,913 |
| 1,920 | 21,375,400 |
| 1,930 | 19,782,373 |
| 1,910 | 13,592,350 |
[ { "decade": 1950, "population": 37545138 }, { "decade": 1960, "population": 35405002 }, { "decade": 1990, "population": 33309594 }, { "decade": 2000, "population": 33041629 }, { "decade": 1980, "population": 32349146 }, { "decade": 1970, "population": 29238092 }, { "decade": 1940, "population": 27776913 }, { "decade": 1920, "population": 21375400 }, { "decade": 1930, "population": 19782373 }, { "decade": 1910, "population": 13592350 } ]
SELECT (floor(base.year/10))*10 as decade, COALESCE(SUM(base.number),0) as population FROM `bigquery-public-data.usa_names.usa_1910_2013` as base GROUP BY 1 ORDER BY 2 desc LIMIT 10
Cohorts
source: names is from( table('bigquery-public-data.usa_names.usa_1910_2013') -> { group_by: decade is floor(`year` / 10) * 10 state gender aggregate: cohort_population is `number`.sum() nest: by_name is { group_by: name aggregate: population is `number`.sum() } } ) { measure: births_per_100k is floor(by_name.population.sum() / cohort_population.sum() * 100000) measure: total_cohort_population is cohort_population.sum() dimension: name is concat(by_name.name, '') } query: names -> { group_by: state gender aggregate: total_cohort_population nest: names is { where: name ? 'Michael' | 'Lloyd' | 'Olivia' group_by: name aggregate: population is by_name.population.sum() group_by: births_per_100k } }
| state | gender | total_​cohort_​population | names | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CA | M | 15,011,405 |
| ||||||||||||
| CA | F | 13,799,158 |
| ||||||||||||
| NY | M | 12,203,961 |
| ||||||||||||
| NY | F | 11,490,175 |
| ||||||||||||
| TX | M | 11,126,246 |
| ||||||||||||
| TX | F | 10,341,113 |
| ||||||||||||
| PA | M | 8,497,961 |
| ||||||||||||
| PA | F | 8,163,949 |
| ||||||||||||
| IL | M | 7,845,252 |
| ||||||||||||
| IL | F | 7,333,624 |
| ||||||||||||
| OH | M | 7,324,810 |
| ||||||||||||
| OH | F | 6,876,716 |
| ||||||||||||
| MI | M | 6,036,661 |
| ||||||||||||
| MI | F | 5,606,794 |
| ||||||||||||
| FL | M | 4,910,950 |
| ||||||||||||
| FL | F | 4,366,273 |
| ||||||||||||
| NC | M | 4,326,810 |
| ||||||||||||
| NJ | M | 4,315,822 |
| ||||||||||||
| GA | M | 4,214,825 |
| ||||||||||||
| NC | F | 4,113,425 |
|
[ { "state": "CA", "gender": "M", "total_cohort_population": 15011405, "names": [ { "name": "Michael", "population": 420127, "births_per_100k": 2798 }, { "name": "Lloyd", "population": 8380, "births_per_100k": 55 } ] }, { "state": "CA", "gender": "F", "total_cohort_population": 13799158, "names": [ { "name": "Olivia", "population": 33794, "births_per_100k": 244 }, { "name": "Michael", "population": 2428, "births_per_100k": 19 } ] }, { "state": "NY", "gender": "M", "total_cohort_population": 12203961, "names": [ { "name": "Michael", "population": 430732, "births_per_100k": 3529 }, { "name": "Lloyd", "population": 7568, "births_per_100k": 62 }, { "name": "Olivia", "population": 5, "births_per_100k": 0 } ] }, { "state": "NY", "gender": "F", "total_cohort_population": 11490175, "names": [ { "name": "Olivia", "population": 23219, "births_per_100k": 202 }, { "name": "Michael", "population": 1761, "births_per_100k": 16 } ] }, { "state": "TX", "gender": "M", "total_cohort_population": 11126246, "names": [ { "name": "Michael", "population": 223900, "births_per_100k": 2012 }, { "name": "Lloyd", "population": 8461, "births_per_100k": 76 }, { "name": "Olivia", "population": 6, "births_per_100k": 1 } ] }, { "state": "TX", "gender": "F", "total_cohort_population": 10341113, "names": [ { "name": "Olivia", "population": 25746, "births_per_100k": 248 }, { "name": "Michael", "population": 1420, "births_per_100k": 16 }, { "name": "Lloyd", "population": 15, "births_per_100k": 1 } ] }, { "state": "PA", "gender": "M", "total_cohort_population": 8497961, "names": [ { "name": "Michael", "population": 266380, "births_per_100k": 3134 }, { "name": "Lloyd", "population": 7874, "births_per_100k": 92 }, { "name": "Olivia", "population": 22, "births_per_100k": 2 } ] }, { "state": "PA", "gender": "F", "total_cohort_population": 8163949, "names": [ { "name": "Olivia", "population": 16292, "births_per_100k": 199 }, { "name": "Michael", "population": 910, "births_per_100k": 11 } ] }, { "state": "IL", "gender": "M", "total_cohort_population": 7845252, "names": [ { "name": "Michael", "population": 251741, "births_per_100k": 3208 }, { "name": "Lloyd", "population": 7207, "births_per_100k": 91 } ] }, { "state": "IL", "gender": "F", "total_cohort_population": 7333624, "names": [ { "name": "Olivia", "population": 16450, "births_per_100k": 224 }, { "name": "Michael", "population": 989, "births_per_100k": 17 } ] }, { "state": "OH", "gender": "M", "total_cohort_population": 7324810, "names": [ { "name": "Michael", "population": 225302, "births_per_100k": 3075 }, { "name": "Lloyd", "population": 6755, "births_per_100k": 92 } ] }, { "state": "OH", "gender": "F", "total_cohort_population": 6876716, "names": [ { "name": "Olivia", "population": 16787, "births_per_100k": 244 }, { "name": "Michael", "population": 969, "births_per_100k": 18 } ] }, { "state": "MI", "gender": "M", "total_cohort_population": 6036661, "names": [ { "name": "Michael", "population": 194851, "births_per_100k": 3227 }, { "name": "Lloyd", "population": 6130, "births_per_100k": 101 } ] }, { "state": "MI", "gender": "F", "total_cohort_population": 5606794, "names": [ { "name": "Olivia", "population": 13575, "births_per_100k": 242 }, { "name": "Michael", "population": 755, "births_per_100k": 17 } ] }, { "state": "FL", "gender": "M", "total_cohort_population": 4910950, "names": [ { "name": "Michael", "population": 138882, "births_per_100k": 2828 }, { "name": "Lloyd", "population": 2876, "births_per_100k": 58 } ] }, { "state": "FL", "gender": "F", "total_cohort_population": 4366273, "names": [ { "name": "Olivia", "population": 15208, "births_per_100k": 348 }, { "name": "Michael", "population": 691, "births_per_100k": 18 } ] }, { "state": "NC", "gender": "M", "total_cohort_population": 4326810, "names": [ { "name": "Michael", "population": 92414, "births_per_100k": 2135 }, { "name": "Lloyd", "population": 4367, "births_per_100k": 100 } ] }, { "state": "NJ", "gender": "M", "total_cohort_population": 4315822, "names": [ { "name": "Michael", "population": 165385, "births_per_100k": 3832 }, { "name": "Lloyd", "population": 1720, "births_per_100k": 41 } ] }, { "state": "GA", "gender": "M", "total_cohort_population": 4214825, "names": [ { "name": "Michael", "population": 87684, "births_per_100k": 2080 }, { "name": "Lloyd", "population": 2508, "births_per_100k": 59 } ] }, { "state": "NC", "gender": "F", "total_cohort_population": 4113425, "names": [ { "name": "Olivia", "population": 10671, "births_per_100k": 259 }, { "name": "Michael", "population": 416, "births_per_100k": 19 } ] } ]
WITH __stage0 AS ( SELECT group_set, (floor(base.year/10))*10 as decade__0, base.state as state__0, base.gender as gender__0, CASE WHEN group_set=0 THEN COALESCE(SUM(base.number),0) END as cohort_population__0, CASE WHEN group_set=1 THEN base.name END as name__1, CASE WHEN group_set=1 THEN COALESCE(SUM(base.number),0) END as population__1 FROM `bigquery-public-data.usa_names.usa_1910_2013` as base CROSS JOIN (SELECT row_number() OVER() -1 group_set FROM UNNEST(GENERATE_ARRAY(0,1,1))) GROUP BY 1,2,3,4,6 ) , __stage1 AS ( SELECT decade__0 as decade, state__0 as state, gender__0 as gender, ANY_VALUE(CASE WHEN group_set=0 THEN cohort_population__0 END) as cohort_population, ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT( name__1 as name, population__1 as population ) END IGNORE NULLS ORDER BY population__1 desc ) as by_name FROM __stage0 GROUP BY 1,2,3 ORDER BY 4 desc ) , __stage2 AS ( SELECT group_set, names.state as state__0, names.gender as gender__0, CASE WHEN group_set=0 THEN COALESCE(CAST(( ( SUM(DISTINCT (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) + (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001 )) - SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001) )/(1*1.0)) as FLOAT64),0) END as total_cohort_population__0, CASE WHEN group_set=1 THEN concat(by_name_0.name,'') END as name__1, CASE WHEN group_set=1 THEN COALESCE(SUM(by_name_0.population),0) END as population__1, floor((CASE WHEN group_set=1 THEN COALESCE(SUM(by_name_0.population),0) END/CASE WHEN group_set=1 THEN COALESCE(CAST(( ( SUM(DISTINCT (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) + (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001 )) - SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001) )/(1*1.0)) as FLOAT64),0) END)*100000) as births_per_100k__1 FROM (SELECT GENERATE_UUID() as __distinct_key, * FROM __stage1 as x) as names LEFT JOIN UNNEST(names.by_name) as by_name_0 CROSS JOIN (SELECT row_number() OVER() -1 group_set FROM UNNEST(GENERATE_ARRAY(0,1,1))) WHERE (group_set NOT IN (1) OR (group_set IN (1) AND ((concat(by_name_0.name,''))='Michael')or(((concat(by_name_0.name,''))='Lloyd')or((concat(by_name_0.name,''))='Olivia')))) GROUP BY 1,2,3,5 ) SELECT state__0 as state, gender__0 as gender, ANY_VALUE(CASE WHEN group_set=0 THEN total_cohort_population__0 END) as total_cohort_population, ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT( name__1 as name, population__1 as population, births_per_100k__1 as births_per_100k ) END IGNORE NULLS ORDER BY population__1 desc ) as names FROM __stage2 GROUP BY 1,2 ORDER BY 3 desc
Dashboard
query: names -> name_dashboard { where: name ~ 'Mich%' }| name | total_​population | state_​map | decade_​graph |
|---|---|---|---|
| Michael | 4,396,482 | ||
| Michelle | 813,655 | ||
| Michele | 221,811 | ||
| Micheal | 150,977 | ||
| Michaela | 48,892 | ||
| Michel | 7,062 | ||
| Michell | 4,377 | ||
| Michal | 2,402 | ||
| Michale | 954 | ||
| Michelina | 909 | ||
| Michaella | 711 | ||
| Michela | 621 | ||
| Michaelangelo | 579 | ||
| Michaelene | 477 | ||
| Michala | 465 |
[ { "name": "Michael", "total_population": 4396482, "state_map": [ { "state": "RI", "births_per_100k": 3689 }, { "state": "DE", "births_per_100k": 3312 }, { "state": "AK", "births_per_100k": 3309 }, { "state": "VT", "births_per_100k": 3026 }, { "state": "NH", "births_per_100k": 2795 }, { "state": "ME", "births_per_100k": 2792 }, { "state": "WY", "births_per_100k": 2650 }, { "state": "HI", "births_per_100k": 2518 }, { "state": "CT", "births_per_100k": 2481 }, { "state": "NV", "births_per_100k": 2406 }, { "state": "DC", "births_per_100k": 2343 }, { "state": "MT", "births_per_100k": 2281 }, { "state": "MA", "births_per_100k": 2234 }, { "state": "NJ", "births_per_100k": 2225 }, { "state": "SD", "births_per_100k": 2218 }, { "state": "ND", "births_per_100k": 1968 }, { "state": "MD", "births_per_100k": 1960 }, { "state": "ID", "births_per_100k": 1950 }, { "state": "WI", "births_per_100k": 1911 }, { "state": "NE", "births_per_100k": 1909 }, { "state": "OR", "births_per_100k": 1862 }, { "state": "IL", "births_per_100k": 1849 }, { "state": "MI", "births_per_100k": 1832 }, { "state": "NY", "births_per_100k": 1814 }, { "state": "WV", "births_per_100k": 1792 }, { "state": "IA", "births_per_100k": 1766 }, { "state": "OH", "births_per_100k": 1758 }, { "state": "CO", "births_per_100k": 1735 }, { "state": "NM", "births_per_100k": 1728 }, { "state": "MN", "births_per_100k": 1695 }, { "state": "IN", "births_per_100k": 1684 }, { "state": "WA", "births_per_100k": 1670 }, { "state": "MO", "births_per_100k": 1654 }, { "state": "VA", "births_per_100k": 1650 }, { "state": "PA", "births_per_100k": 1606 }, { "state": "AZ", "births_per_100k": 1599 }, { "state": "KS", "births_per_100k": 1598 }, { "state": "UT", "births_per_100k": 1597 }, { "state": "FL", "births_per_100k": 1555 }, { "state": "OK", "births_per_100k": 1539 }, { "state": "LA", "births_per_100k": 1429 }, { "state": "NC", "births_per_100k": 1398 }, { "state": "CA", "births_per_100k": 1393 }, { "state": "AR", "births_per_100k": 1380 }, { "state": "TN", "births_per_100k": 1364 }, { "state": "SC", "births_per_100k": 1363 }, { "state": "KY", "births_per_100k": 1345 }, { "state": "AL", "births_per_100k": 1241 }, { "state": "MS", "births_per_100k": 1212 }, { "state": "GA", "births_per_100k": 1140 }, { "state": "TX", "births_per_100k": 1024 } ], "decade_graph": [ { "decade": 1970, "births_per_100k": 4562, "baby_gender": "Male" }, { "decade": 1960, "births_per_100k": 4510, "baby_gender": "Male" }, { "decade": 1950, "births_per_100k": 4301, "baby_gender": "Male" }, { "decade": 1980, "births_per_100k": 3848, "baby_gender": "Male" }, { "decade": 1990, "births_per_100k": 2587, "baby_gender": "Male" }, { "decade": 1940, "births_per_100k": 2367, "baby_gender": "Male" }, { "decade": 2000, "births_per_100k": 1409, "baby_gender": "Male" }, { "decade": 2010, "births_per_100k": 884, "baby_gender": "Male" }, { "decade": 2020, "births_per_100k": 632, "baby_gender": "Male" }, { "decade": 1930, "births_per_100k": 564, "baby_gender": "Male" }, { "decade": 1910, "births_per_100k": 501, "baby_gender": "Male" }, { "decade": 1920, "births_per_100k": 366, "baby_gender": "Male" }, { "decade": 1970, "births_per_100k": 35, "baby_gender": "Female" }, { "decade": 1980, "births_per_100k": 32, "baby_gender": "Female" }, { "decade": 1960, "births_per_100k": 19, "baby_gender": "Female" }, { "decade": 1950, "births_per_100k": 10, "baby_gender": "Female" }, { "decade": 1990, "births_per_100k": 10, "baby_gender": "Female" }, { "decade": 1940, "births_per_100k": 8, "baby_gender": "Female" }, { "decade": 1930, "births_per_100k": 4, "baby_gender": "Female" }, { "decade": 1920, "births_per_100k": 4, "baby_gender": "Female" }, { "decade": 2000, "births_per_100k": 3, "baby_gender": "Female" }, { "decade": 2010, "births_per_100k": 0, "baby_gender": "Female" }, { "decade": 1910, "births_per_100k": 0, "baby_gender": "Female" } ] }, { "name": "Michelle", "total_population": 813655, "state_map": [ { "state": "VT", "births_per_100k": 1137 }, { "state": "AK", "births_per_100k": 1017 }, { "state": "WY", "births_per_100k": 992 }, { "state": "HI", "births_per_100k": 992 }, { "state": "DE", "births_per_100k": 920 }, { "state": "RI", "births_per_100k": 903 }, { "state": "ME", "births_per_100k": 889 }, { "state": "NH", "births_per_100k": 878 }, { "state": "NE", "births_per_100k": 834 }, { "state": "SD", "births_per_100k": 834 }, { "state": "ND", "births_per_100k": 825 }, { "state": "NM", "births_per_100k": 773 }, { "state": "MT", "births_per_100k": 768 }, { "state": "CO", "births_per_100k": 762 }, { "state": "NV", "births_per_100k": 756 }, { "state": "IA", "births_per_100k": 750 }, { "state": "CT", "births_per_100k": 746 }, { "state": "KS", "births_per_100k": 740 }, { "state": "OR", "births_per_100k": 735 }, { "state": "DC", "births_per_100k": 725 }, { "state": "UT", "births_per_100k": 721 }, { "state": "WA", "births_per_100k": 704 }, { "state": "ID", "births_per_100k": 695 }, { "state": "AZ", "births_per_100k": 683 }, { "state": "MO", "births_per_100k": 659 }, { "state": "MA", "births_per_100k": 648 }, { "state": "IN", "births_per_100k": 607 }, { "state": "MN", "births_per_100k": 589 }, { "state": "MD", "births_per_100k": 578 }, { "state": "MI", "births_per_100k": 560 }, { "state": "WI", "births_per_100k": 527 }, { "state": "OH", "births_per_100k": 521 }, { "state": "OK", "births_per_100k": 502 }, { "state": "LA", "births_per_100k": 502 }, { "state": "NJ", "births_per_100k": 501 }, { "state": "VA", "births_per_100k": 486 }, { "state": "IL", "births_per_100k": 466 }, { "state": "FL", "births_per_100k": 458 }, { "state": "PA", "births_per_100k": 456 }, { "state": "CA", "births_per_100k": 446 }, { "state": "WV", "births_per_100k": 438 }, { "state": "AR", "births_per_100k": 417 }, { "state": "NY", "births_per_100k": 414 }, { "state": "SC", "births_per_100k": 402 }, { "state": "KY", "births_per_100k": 363 }, { "state": "TN", "births_per_100k": 324 }, { "state": "GA", "births_per_100k": 314 }, { "state": "TX", "births_per_100k": 308 }, { "state": "MS", "births_per_100k": 296 }, { "state": "NC", "births_per_100k": 283 }, { "state": "AL", "births_per_100k": 277 } ], "decade_graph": [ { "decade": 1970, "births_per_100k": 1814, "baby_gender": "Female" }, { "decade": 1960, "births_per_100k": 1230, "baby_gender": "Female" }, { "decade": 1980, "births_per_100k": 1018, "baby_gender": "Female" }, { "decade": 1990, "births_per_100k": 559, "baby_gender": "Female" }, { "decade": 2000, "births_per_100k": 283, "baby_gender": "Female" }, { "decade": 1950, "births_per_100k": 258, "baby_gender": "Female" }, { "decade": 2010, "births_per_100k": 120, "baby_gender": "Female" }, { "decade": 2020, "births_per_100k": 65, "baby_gender": "Female" }, { "decade": 1940, "births_per_100k": 40, "baby_gender": "Female" }, { "decade": 1970, "births_per_100k": 5, "baby_gender": "Male" }, { "decade": 1980, "births_per_100k": 4, "baby_gender": "Male" }, { "decade": 1930, "births_per_100k": 4, "baby_gender": "Female" }, { "decade": 1990, "births_per_100k": 3, "baby_gender": "Male" }, { "decade": 1960, "births_per_100k": 2, "baby_gender": "Male" }, { "decade": 1920, "births_per_100k": 1, "baby_gender": "Female" }, { "decade": 2000, "births_per_100k": 0, "baby_gender": "Male" } ] }, { "name": "Michele", "total_population": 221811, "state_map": [ { "state": "DE", "births_per_100k": 472 }, { "state": "CT", "births_per_100k": 447 }, { "state": "HI", "births_per_100k": 368 }, { "state": "VT", "births_per_100k": 351 }, { "state": "MD", "births_per_100k": 325 }, { "state": "RI", "births_per_100k": 313 }, { "state": "DC", "births_per_100k": 294 }, { "state": "AK", "births_per_100k": 287 }, { "state": "NH", "births_per_100k": 276 }, { "state": "NJ", "births_per_100k": 274 }, { "state": "SD", "births_per_100k": 265 }, { "state": "NV", "births_per_100k": 256 }, { "state": "MT", "births_per_100k": 245 }, { "state": "WI", "births_per_100k": 234 }, { "state": "ME", "births_per_100k": 232 }, { "state": "NE", "births_per_100k": 224 }, { "state": "IA", "births_per_100k": 224 }, { "state": "WY", "births_per_100k": 217 }, { "state": "ND", "births_per_100k": 216 }, { "state": "PA", "births_per_100k": 209 }, { "state": "MN", "births_per_100k": 208 }, { "state": "UT", "births_per_100k": 200 }, { "state": "MI", "births_per_100k": 199 }, { "state": "IN", "births_per_100k": 195 }, { "state": "OR", "births_per_100k": 187 }, { "state": "MO", "births_per_100k": 186 }, { "state": "MA", "births_per_100k": 184 }, { "state": "WA", "births_per_100k": 176 }, { "state": "ID", "births_per_100k": 175 }, { "state": "OH", "births_per_100k": 171 }, { "state": "KS", "births_per_100k": 171 }, { "state": "CO", "births_per_100k": 163 }, { "state": "NY", "births_per_100k": 153 }, { "state": "WV", "births_per_100k": 148 }, { "state": "IL", "births_per_100k": 139 }, { "state": "NM", "births_per_100k": 136 }, { "state": "VA", "births_per_100k": 132 }, { "state": "AZ", "births_per_100k": 116 }, { "state": "LA", "births_per_100k": 112 }, { "state": "KY", "births_per_100k": 112 }, { "state": "OK", "births_per_100k": 106 }, { "state": "FL", "births_per_100k": 99 }, { "state": "CA", "births_per_100k": 95 }, { "state": "AR", "births_per_100k": 87 }, { "state": "SC", "births_per_100k": 73 }, { "state": "AL", "births_per_100k": 68 }, { "state": "GA", "births_per_100k": 64 }, { "state": "TX", "births_per_100k": 57 }, { "state": "NC", "births_per_100k": 55 }, { "state": "MS", "births_per_100k": 51 }, { "state": "TN", "births_per_100k": 47 } ], "decade_graph": [ { "decade": 1960, "births_per_100k": 513, "baby_gender": "Female" }, { "decade": 1970, "births_per_100k": 411, "baby_gender": "Female" }, { "decade": 1950, "births_per_100k": 231, "baby_gender": "Female" }, { "decade": 1980, "births_per_100k": 113, "baby_gender": "Female" }, { "decade": 1940, "births_per_100k": 84, "baby_gender": "Female" }, { "decade": 1990, "births_per_100k": 36, "baby_gender": "Female" }, { "decade": 2000, "births_per_100k": 10, "baby_gender": "Female" }, { "decade": 1910, "births_per_100k": 7, "baby_gender": "Male" }, { "decade": 1970, "births_per_100k": 5, "baby_gender": "Male" }, { "decade": 1930, "births_per_100k": 5, "baby_gender": "Female" }, { "decade": 1920, "births_per_100k": 5, "baby_gender": "Male" }, { "decade": 2020, "births_per_100k": 4, "baby_gender": "Female" }, { "decade": 1960, "births_per_100k": 2, "baby_gender": "Male" }, { "decade": 1980, "births_per_100k": 2, "baby_gender": "Male" }, { "decade": 2010, "births_per_100k": 2, "baby_gender": "Female" }, { "decade": 1920, "births_per_100k": 2, "baby_gender": "Female" }, { "decade": 1990, "births_per_100k": 1, "baby_gender": "Male" }, { "decade": 1950, "births_per_100k": 0, "baby_gender": "Male" }, { "decade": 1930, "births_per_100k": 0, "baby_gender": "Male" }, { "decade": 1940, "births_per_100k": 0, "baby_gender": "Male" } ] }, { "name": "Micheal", "total_population": 150977, "state_map": [ { "state": "MS", "births_per_100k": 220 }, { "state": "SD", "births_per_100k": 179 }, { "state": "SC", "births_per_100k": 174 }, { "state": "AR", "births_per_100k": 171 }, { "state": "LA", "births_per_100k": 170 }, { "state": "AL", "births_per_100k": 168 }, { "state": "MT", "births_per_100k": 163 }, { "state": "TN", "births_per_100k": 161 }, { "state": "OK", "births_per_100k": 160 }, { "state": "WY", "births_per_100k": 155 }, { "state": "IA", "births_per_100k": 149 }, { "state": "ID", "births_per_100k": 144 }, { "state": "NC", "births_per_100k": 142 }, { "state": "NM", "births_per_100k": 140 }, { "state": "DC", "births_per_100k": 139 }, { "state": "ND", "births_per_100k": 138 }, { "state": "AK", "births_per_100k": 135 }, { "state": "OR", "births_per_100k": 132 }, { "state": "KY", "births_per_100k": 131 }, { "state": "NE", "births_per_100k": 131 }, { "state": "WV", "births_per_100k": 127 }, { "state": "MO", "births_per_100k": 125 }, { "state": "KS", "births_per_100k": 124 }, { "state": "GA", "births_per_100k": 121 }, { "state": "WA", "births_per_100k": 120 }, { "state": "IN", "births_per_100k": 109 }, { "state": "MI", "births_per_100k": 106 }, { "state": "CO", "births_per_100k": 102 }, { "state": "VA", "births_per_100k": 99 }, { "state": "NV", "births_per_100k": 93 }, { "state": "UT", "births_per_100k": 89 }, { "state": "MD", "births_per_100k": 89 }, { "state": "MN", "births_per_100k": 87 }, { "state": "AZ", "births_per_100k": 85 }, { "state": "FL", "births_per_100k": 84 }, { "state": "WI", "births_per_100k": 82 }, { "state": "ME", "births_per_100k": 81 }, { "state": "IL", "births_per_100k": 81 }, { "state": "VT", "births_per_100k": 80 }, { "state": "OH", "births_per_100k": 79 }, { "state": "TX", "births_per_100k": 70 }, { "state": "NH", "births_per_100k": 63 }, { "state": "DE", "births_per_100k": 60 }, { "state": "CA", "births_per_100k": 47 }, { "state": "PA", "births_per_100k": 47 }, { "state": "CT", "births_per_100k": 43 }, { "state": "NY", "births_per_100k": 42 }, { "state": "RI", "births_per_100k": 42 }, { "state": "NJ", "births_per_100k": 41 }, { "state": "MA", "births_per_100k": 38 }, { "state": "HI", "births_per_100k": 32 } ], "decade_graph": [ { "decade": 1950, "births_per_100k": 209, "baby_gender": "Male" }, { "decade": 1960, "births_per_100k": 172, "baby_gender": "Male" }, { "decade": 1970, "births_per_100k": 152, "baby_gender": "Male" }, { "decade": 1980, "births_per_100k": 108, "baby_gender": "Male" }, { "decade": 1940, "births_per_100k": 73, "baby_gender": "Male" }, { "decade": 1990, "births_per_100k": 71, "baby_gender": "Male" }, { "decade": 2000, "births_per_100k": 39, "baby_gender": "Male" }, { "decade": 1910, "births_per_100k": 32, "baby_gender": "Male" }, { "decade": 1920, "births_per_100k": 17, "baby_gender": "Male" }, { "decade": 2010, "births_per_100k": 16, "baby_gender": "Male" }, { "decade": 2020, "births_per_100k": 13, "baby_gender": "Male" }, { "decade": 1930, "births_per_100k": 12, "baby_gender": "Male" }, { "decade": 2000, "births_per_100k": 3, "baby_gender": "Female" }, { "decade": 1970, "births_per_100k": 2, "baby_gender": "Female" }, { "decade": 1960, "births_per_100k": 1, "baby_gender": "Female" }, { "decade": 1950, "births_per_100k": 0, "baby_gender": "Female" }, { "decade": 1980, "births_per_100k": 0, "baby_gender": "Female" }, { "decade": 1990, "births_per_100k": 0, "baby_gender": "Female" } ] }, { "name": "Michaela", "total_population": 48892, "state_map": [ { "state": "VT", "births_per_100k": 229 }, { "state": "RI", "births_per_100k": 209 }, { "state": "SD", "births_per_100k": 179 }, { "state": "ME", "births_per_100k": 162 }, { "state": "MT", "births_per_100k": 160 }, { "state": "NE", "births_per_100k": 148 }, { "state": "AK", "births_per_100k": 115 }, { "state": "NH", "births_per_100k": 115 }, { "state": "WY", "births_per_100k": 110 }, { "state": "ND", "births_per_100k": 102 }, { "state": "CT", "births_per_100k": 96 }, { "state": "MS", "births_per_100k": 93 }, { "state": "SC", "births_per_100k": 92 }, { "state": "HI", "births_per_100k": 91 }, { "state": "KS", "births_per_100k": 91 }, { "state": "NM", "births_per_100k": 90 }, { "state": "DE", "births_per_100k": 89 }, { "state": "MD", "births_per_100k": 86 }, { "state": "KY", "births_per_100k": 86 }, { "state": "MA", "births_per_100k": 84 }, { "state": "TN", "births_per_100k": 81 }, { "state": "MN", "births_per_100k": 80 }, { "state": "WV", "births_per_100k": 79 }, { "state": "WI", "births_per_100k": 77 }, { "state": "AR", "births_per_100k": 76 }, { "state": "OR", "births_per_100k": 73 }, { "state": "WA", "births_per_100k": 72 }, { "state": "NC", "births_per_100k": 72 }, { "state": "OK", "births_per_100k": 71 }, { "state": "VA", "births_per_100k": 70 }, { "state": "IN", "births_per_100k": 69 }, { "state": "ID", "births_per_100k": 68 }, { "state": "AL", "births_per_100k": 68 }, { "state": "MO", "births_per_100k": 66 }, { "state": "IA", "births_per_100k": 65 }, { "state": "CO", "births_per_100k": 63 }, { "state": "AZ", "births_per_100k": 61 }, { "state": "UT", "births_per_100k": 60 }, { "state": "GA", "births_per_100k": 60 }, { "state": "NV", "births_per_100k": 59 }, { "state": "DC", "births_per_100k": 55 }, { "state": "FL", "births_per_100k": 49 }, { "state": "LA", "births_per_100k": 47 }, { "state": "PA", "births_per_100k": 47 }, { "state": "OH", "births_per_100k": 43 }, { "state": "NJ", "births_per_100k": 43 }, { "state": "MI", "births_per_100k": 40 }, { "state": "IL", "births_per_100k": 40 }, { "state": "TX", "births_per_100k": 37 }, { "state": "NY", "births_per_100k": 36 }, { "state": "CA", "births_per_100k": 28 } ], "decade_graph": [ { "decade": 1990, "births_per_100k": 149, "baby_gender": "Female" }, { "decade": 2000, "births_per_100k": 84, "baby_gender": "Female" }, { "decade": 2010, "births_per_100k": 45, "baby_gender": "Female" }, { "decade": 2020, "births_per_100k": 37, "baby_gender": "Female" }, { "decade": 1980, "births_per_100k": 27, "baby_gender": "Female" }, { "decade": 1970, "births_per_100k": 8, "baby_gender": "Female" }, { "decade": 1960, "births_per_100k": 4, "baby_gender": "Female" }, { "decade": 1950, "births_per_100k": 3, "baby_gender": "Female" }, { "decade": 1940, "births_per_100k": 2, "baby_gender": "Female" }, { "decade": 1990, "births_per_100k": 0, "baby_gender": "Male" } ] }, { "name": "Michel", "total_population": 7062, "state_map": [ { "state": "NH", "births_per_100k": 46 }, { "state": "ME", "births_per_100k": 30 }, { "state": "VT", "births_per_100k": 12 }, { "state": "LA", "births_per_100k": 11 }, { "state": "MA", "births_per_100k": 8 }, { "state": "MS", "births_per_100k": 8 }, { "state": "OK", "births_per_100k": 7 }, { "state": "MO", "births_per_100k": 7 }, { "state": "AR", "births_per_100k": 7 }, { "state": "IN", "births_per_100k": 7 }, { "state": "FL", "births_per_100k": 6 }, { "state": "IA", "births_per_100k": 6 }, { "state": "ID", "births_per_100k": 6 }, { "state": "NY", "births_per_100k": 5 }, { "state": "KY", "births_per_100k": 5 }, { "state": "WA", "births_per_100k": 5 }, { "state": "TN", "births_per_100k": 5 }, { "state": "CA", "births_per_100k": 5 }, { "state": "CO", "births_per_100k": 5 }, { "state": "TX", "births_per_100k": 4 }, { "state": "MI", "births_per_100k": 4 }, { "state": "VA", "births_per_100k": 4 }, { "state": "OH", "births_per_100k": 4 }, { "state": "SC", "births_per_100k": 4 }, { "state": "GA", "births_per_100k": 4 }, { "state": "OR", "births_per_100k": 4 }, { "state": "KS", "births_per_100k": 3 }, { "state": "CT", "births_per_100k": 3 }, { "state": "IL", "births_per_100k": 3 }, { "state": "NC", "births_per_100k": 3 }, { "state": "AL", "births_per_100k": 3 }, { "state": "MD", "births_per_100k": 2 }, { "state": "NJ", "births_per_100k": 2 }, { "state": "WI", "births_per_100k": 2 }, { "state": "MN", "births_per_100k": 2 }, { "state": "PA", "births_per_100k": 1 }, { "state": "AZ", "births_per_100k": 1 } ], "decade_graph": [ { "decade": 1950, "births_per_100k": 9, "baby_gender": "Male" }, { "decade": 1960, "births_per_100k": 8, "baby_gender": "Male" }, { "decade": 1980, "births_per_100k": 6, "baby_gender": "Male" }, { "decade": 1970, "births_per_100k": 6, "baby_gender": "Male" }, { "decade": 1990, "births_per_100k": 4, "baby_gender": "Male" }, { "decade": 1940, "births_per_100k": 4, "baby_gender": "Male" }, { "decade": 1910, "births_per_100k": 4, "baby_gender": "Male" }, { "decade": 1930, "births_per_100k": 3, "baby_gender": "Male" }, { "decade": 1970, "births_per_100k": 3, "baby_gender": "Female" }, { "decade": 2000, "births_per_100k": 3, "baby_gender": "Female" }, { "decade": 2000, "births_per_100k": 3, "baby_gender": "Male" }, { "decade": 1920, "births_per_100k": 3, "baby_gender": "Male" }, { "decade": 1960, "births_per_100k": 3, "baby_gender": "Female" }, { "decade": 1990, "births_per_100k": 3, "baby_gender": "Female" }, { "decade": 2020, "births_per_100k": 2, "baby_gender": "Male" }, { "decade": 1980, "births_per_100k": 2, "baby_gender": "Female" }, { "decade": 1940, "births_per_100k": 2, "baby_gender": "Female" }, { "decade": 1950, "births_per_100k": 1, "baby_gender": "Female" }, { "decade": 2010, "births_per_100k": 1, "baby_gender": "Male" }, { "decade": 2010, "births_per_100k": 0, "baby_gender": "Female" } ] }, { "name": "Michell", "total_population": 4377, "state_map": [ { "state": "MS", "births_per_100k": 21 }, { "state": "LA", "births_per_100k": 16 }, { "state": "MO", "births_per_100k": 14 }, { "state": "AR", "births_per_100k": 13 }, { "state": "CO", "births_per_100k": 10 }, { "state": "NV", "births_per_100k": 10 }, { "state": "GA", "births_per_100k": 9 }, { "state": "KS", "births_per_100k": 9 }, { "state": "OK", "births_per_100k": 9 }, { "state": "AL", "births_per_100k": 9 }, { "state": "KY", "births_per_100k": 9 }, { "state": "IN", "births_per_100k": 9 }, { "state": "SC", "births_per_100k": 8 }, { "state": "DC", "births_per_100k": 8 }, { "state": "AZ", "births_per_100k": 7 }, { "state": "CA", "births_per_100k": 6 }, { "state": "FL", "births_per_100k": 6 }, { "state": "WA", "births_per_100k": 6 }, { "state": "TX", "births_per_100k": 6 }, { "state": "OH", "births_per_100k": 6 }, { "state": "NY", "births_per_100k": 5 }, { "state": "MI", "births_per_100k": 5 }, { "state": "IL", "births_per_100k": 5 }, { "state": "MD", "births_per_100k": 5 }, { "state": "NJ", "births_per_100k": 4 }, { "state": "PA", "births_per_100k": 4 }, { "state": "WI", "births_per_100k": 4 }, { "state": "NC", "births_per_100k": 4 }, { "state": "TN", "births_per_100k": 3 }, { "state": "MN", "births_per_100k": 3 }, { "state": "OR", "births_per_100k": 3 }, { "state": "MA", "births_per_100k": 2 }, { "state": "VA", "births_per_100k": 2 }, { "state": "IA", "births_per_100k": 2 } ], "decade_graph": [ { "decade": 1970, "births_per_100k": 13, "baby_gender": "Female" }, { "decade": 1960, "births_per_100k": 7, "baby_gender": "Female" }, { "decade": 1980, "births_per_100k": 6, "baby_gender": "Female" }, { "decade": 1990, "births_per_100k": 6, "baby_gender": "Female" }, { "decade": 2000, "births_per_100k": 5, "baby_gender": "Female" }, { "decade": 2010, "births_per_100k": 1, "baby_gender": "Female" }, { "decade": 1950, "births_per_100k": 0, "baby_gender": "Female" }, { "decade": 1970, "births_per_100k": 0, "baby_gender": "Male" }, { "decade": 1990, "births_per_100k": 0, "baby_gender": "Male" } ] }, { "name": "Michal", "total_population": 2402, "state_map": [ { "state": "IL", "births_per_100k": 8 }, { "state": "UT", "births_per_100k": 8 }, { "state": "NJ", "births_per_100k": 6 }, { "state": "NY", "births_per_100k": 5 }, { "state": "CT", "births_per_100k": 5 }, { "state": "MD", "births_per_100k": 2 }, { "state": "IA", "births_per_100k": 2 }, { "state": "CO", "births_per_100k": 2 }, { "state": "TX", "births_per_100k": 1 }, { "state": "CA", "births_per_100k": 1 }, { "state": "PA", "births_per_100k": 1 }, { "state": "TN", "births_per_100k": 1 }, { "state": "OH", "births_per_100k": 1 }, { "state": "GA", "births_per_100k": 1 }, { "state": "MA", "births_per_100k": 1 }, { "state": "FL", "births_per_100k": 1 }, { "state": "MO", "births_per_100k": 1 }, { "state": "AL", "births_per_100k": 1 }, { "state": "MI", "births_per_100k": 0 } ], "decade_graph": [ { "decade": 2020, "births_per_100k": 19, "baby_gender": "Female" }, { "decade": 2010, "births_per_100k": 6, "baby_gender": "Male" }, { "decade": 2000, "births_per_100k": 5, "baby_gender": "Male" }, { "decade": 1980, "births_per_100k": 4, "baby_gender": "Female" }, { "decade": 1990, "births_per_100k": 4, "baby_gender": "Male" }, { "decade": 2020, "births_per_100k": 4, "baby_gender": "Male" }, { "decade": 2010, "births_per_100k": 4, "baby_gender": "Female" }, { "decade": 1970, "births_per_100k": 3, "baby_gender": "Female" }, { "decade": 1990, "births_per_100k": 3, "baby_gender": "Female" }, { "decade": 2000, "births_per_100k": 2, "baby_gender": "Female" }, { "decade": 1940, "births_per_100k": 2, "baby_gender": "Female" }, { "decade": 1980, "births_per_100k": 1, "baby_gender": "Male" }, { "decade": 1950, "births_per_100k": 1, "baby_gender": "Male" }, { "decade": 1960, "births_per_100k": 0, "baby_gender": "Male" }, { "decade": 1960, "births_per_100k": 0, "baby_gender": "Female" }, { "decade": 1950, "births_per_100k": 0, "baby_gender": "Female" }, { "decade": 1970, "births_per_100k": 0, "baby_gender": "Male" }, { "decade": 1940, "births_per_100k": 0, "baby_gender": "Male" } ] }, { "name": "Michale", "total_population": 954, "state_map": [ { "state": "UT", "births_per_100k": 4 }, { "state": "CA", "births_per_100k": 3 }, { "state": "OK", "births_per_100k": 2 }, { "state": "IL", "births_per_100k": 2 }, { "state": "FL", "births_per_100k": 2 }, { "state": "TX", "births_per_100k": 2 }, { "state": "GA", "births_per_100k": 1 }, { "state": "NY", "births_per_100k": 1 }, { "state": "VA", "births_per_100k": 1 }, { "state": "OH", "births_per_100k": 1 }, { "state": "AZ", "births_per_100k": 1 }, { "state": "MI", "births_per_100k": 1 }, { "state": "PA", "births_per_100k": 1 }, { "state": "TN", "births_per_100k": 1 }, { "state": "NC", "births_per_100k": 1 }, { "state": "IN", "births_per_100k": 1 }, { "state": "KY", "births_per_100k": 1 } ], "decade_graph": [ { "decade": 1980, "births_per_100k": 3, "baby_gender": "Male" }, { "decade": 1970, "births_per_100k": 3, "baby_gender": "Male" }, { "decade": 1950, "births_per_100k": 1, "baby_gender": "Male" }, { "decade": 1960, "births_per_100k": 1, "baby_gender": "Male" }, { "decade": 2010, "births_per_100k": 1, "baby_gender": "Male" }, { "decade": 1990, "births_per_100k": 0, "baby_gender": "Male" } ] }, { "name": "Michelina", "total_population": 909, "state_map": [ { "state": "RI", "births_per_100k": 9 }, { "state": "CT", "births_per_100k": 9 }, { "state": "MA", "births_per_100k": 8 }, { "state": "NJ", "births_per_100k": 7 }, { "state": "NY", "births_per_100k": 6 }, { "state": "PA", "births_per_100k": 1 }, { "state": "IL", "births_per_100k": 0 } ], "decade_graph": [ { "decade": 1920, "births_per_100k": 12, "baby_gender": "Female" }, { "decade": 1910, "births_per_100k": 10, "baby_gender": "Female" }, { "decade": 1930, "births_per_100k": 8, "baby_gender": "Female" }, { "decade": 1940, "births_per_100k": 3, "baby_gender": "Female" }, { "decade": 2020, "births_per_100k": 3, "baby_gender": "Female" }, { "decade": 1950, "births_per_100k": 1, "baby_gender": "Female" }, { "decade": 1970, "births_per_100k": 1, "baby_gender": "Female" }, { "decade": 1960, "births_per_100k": 1, "baby_gender": "Female" }, { "decade": 2000, "births_per_100k": 0, "baby_gender": "Female" }, { "decade": 2010, "births_per_100k": 0, "baby_gender": "Female" }, { "decade": 1990, "births_per_100k": 0, "baby_gender": "Female" } ] }, { "name": "Michaella", "total_population": 711, "state_map": [ { "state": "MA", "births_per_100k": 6 }, { "state": "MO", "births_per_100k": 6 }, { "state": "WA", "births_per_100k": 5 }, { "state": "FL", "births_per_100k": 4 }, { "state": "OH", "births_per_100k": 3 }, { "state": "NY", "births_per_100k": 3 }, { "state": "NC", "births_per_100k": 3 }, { "state": "IN", "births_per_100k": 3 }, { "state": "UT", "births_per_100k": 3 }, { "state": "CO", "births_per_100k": 3 }, { "state": "MI", "births_per_100k": 2 }, { "state": "NJ", "births_per_100k": 2 }, { "state": "IL", "births_per_100k": 2 }, { "state": "PA", "births_per_100k": 2 }, { "state": "CA", "births_per_100k": 1 }, { "state": "TX", "births_per_100k": 1 }, { "state": "GA", "births_per_100k": 1 } ], "decade_graph": [ { "decade": 1990, "births_per_100k": 4, "baby_gender": "Female" }, { "decade": 2020, "births_per_100k": 3, "baby_gender": "Female" }, { "decade": 2010, "births_per_100k": 1, "baby_gender": "Female" }, { "decade": 2000, "births_per_100k": 1, "baby_gender": "Female" }, { "decade": 1980, "births_per_100k": 0, "baby_gender": "Female" }, { "decade": 1960, "births_per_100k": 0, "baby_gender": "Female" } ] }, { "name": "Michela", "total_population": 621, "state_map": [ { "state": "MA", "births_per_100k": 12 }, { "state": "NJ", "births_per_100k": 3 }, { "state": "NY", "births_per_100k": 3 }, { "state": "PA", "births_per_100k": 2 }, { "state": "CA", "births_per_100k": 2 }, { "state": "OH", "births_per_100k": 1 }, { "state": "FL", "births_per_100k": 1 }, { "state": "IL", "births_per_100k": 1 } ], "decade_graph": [ { "decade": 1990, "births_per_100k": 5, "baby_gender": "Female" }, { "decade": 2020, "births_per_100k": 3, "baby_gender": "Female" }, { "decade": 2000, "births_per_100k": 2, "baby_gender": "Female" }, { "decade": 2010, "births_per_100k": 1, "baby_gender": "Female" }, { "decade": 1980, "births_per_100k": 1, "baby_gender": "Female" }, { "decade": 1940, "births_per_100k": 0, "baby_gender": "Female" }, { "decade": 1970, "births_per_100k": 0, "baby_gender": "Female" } ] }, { "name": "Michaelangelo", "total_population": 579, "state_map": [ { "state": "CA", "births_per_100k": 3 }, { "state": "FL", "births_per_100k": 1 }, { "state": "NY", "births_per_100k": 1 }, { "state": "AZ", "births_per_100k": 1 }, { "state": "TX", "births_per_100k": 1 }, { "state": "MA", "births_per_100k": 1 }, { "state": "IL", "births_per_100k": 0 } ], "decade_graph": [ { "decade": 2010, "births_per_100k": 2, "baby_gender": "Male" }, { "decade": 1990, "births_per_100k": 2, "baby_gender": "Male" }, { "decade": 2000, "births_per_100k": 2, "baby_gender": "Male" }, { "decade": 2020, "births_per_100k": 2, "baby_gender": "Male" }, { "decade": 1980, "births_per_100k": 1, "baby_gender": "Male" }, { "decade": 1970, "births_per_100k": 0, "baby_gender": "Male" } ] }, { "name": "Michaelene", "total_population": 477, "state_map": [ { "state": "PA", "births_per_100k": 4 }, { "state": "IL", "births_per_100k": 4 }, { "state": "IA", "births_per_100k": 2 }, { "state": "MI", "births_per_100k": 1 }, { "state": "NJ", "births_per_100k": 1 }, { "state": "OH", "births_per_100k": 1 }, { "state": "IN", "births_per_100k": 1 }, { "state": "NY", "births_per_100k": 0 } ], "decade_graph": [ { "decade": 1940, "births_per_100k": 4, "baby_gender": "Female" }, { "decade": 1960, "births_per_100k": 3, "baby_gender": "Female" }, { "decade": 1950, "births_per_100k": 2, "baby_gender": "Female" }, { "decade": 1930, "births_per_100k": 1, "baby_gender": "Female" }, { "decade": 1970, "births_per_100k": 1, "baby_gender": "Female" }, { "decade": 1980, "births_per_100k": 0, "baby_gender": "Female" } ] }, { "name": "Michala", "total_population": 465, "state_map": [ { "state": "NC", "births_per_100k": 9 }, { "state": "OK", "births_per_100k": 7 }, { "state": "VA", "births_per_100k": 5 }, { "state": "NE", "births_per_100k": 5 }, { "state": "MO", "births_per_100k": 5 }, { "state": "TX", "births_per_100k": 4 }, { "state": "MI", "births_per_100k": 4 }, { "state": "OH", "births_per_100k": 4 }, { "state": "PA", "births_per_100k": 3 }, { "state": "GA", "births_per_100k": 3 }, { "state": "TN", "births_per_100k": 2 }, { "state": "MD", "births_per_100k": 2 }, { "state": "KY", "births_per_100k": 2 }, { "state": "IL", "births_per_100k": 2 }, { "state": "LA", "births_per_100k": 2 }, { "state": "MN", "births_per_100k": 1 }, { "state": "CA", "births_per_100k": 1 }, { "state": "NY", "births_per_100k": 1 }, { "state": "WA", "births_per_100k": 1 }, { "state": "IN", "births_per_100k": 1 }, { "state": "FL", "births_per_100k": 0 } ], "decade_graph": [ { "decade": 1970, "births_per_100k": 5, "baby_gender": "Female" }, { "decade": 1980, "births_per_100k": 4, "baby_gender": "Female" }, { "decade": 1990, "births_per_100k": 3, "baby_gender": "Female" }, { "decade": 2000, "births_per_100k": 0, "baby_gender": "Female" } ] } ]
WITH __stage0 AS ( SELECT group_set, (floor(base.year/10))*10 as decade__0, base.state as state__0, CASE WHEN base.gender='M' THEN 'Male' ELSE 'Female' END as baby_gender__0, base.gender as gender__0, CASE WHEN group_set=0 THEN COALESCE(SUM(base.number),0) END as cohort_population__0, CASE WHEN group_set=1 THEN base.name END as name__1, CASE WHEN group_set=1 THEN COALESCE(SUM(base.number),0) END as population__1 FROM `bigquery-public-data.usa_names.usa_1910_current` as base CROSS JOIN (SELECT row_number() OVER() -1 group_set FROM UNNEST(GENERATE_ARRAY(0,1,1))) GROUP BY 1,2,3,4,5,7 ) , __stage1 AS ( SELECT decade__0 as decade, state__0 as state, baby_gender__0 as baby_gender, gender__0 as gender, ANY_VALUE(CASE WHEN group_set=0 THEN cohort_population__0 END) as cohort_population, ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT( name__1 as name, population__1 as population ) END IGNORE NULLS ORDER BY population__1 desc ) as by_name FROM __stage0 GROUP BY 1,2,3,4 ORDER BY 5 desc ) , __stage2 AS ( SELECT group_set, concat(by_name_0.name,'') as name__0, CASE WHEN group_set=0 THEN COALESCE(SUM(by_name_0.population),0) END as total_population__0, CASE WHEN group_set=1 THEN names.state END as state__1, floor((CASE WHEN group_set=1 THEN COALESCE(SUM(by_name_0.population),0) END/CASE WHEN group_set=1 THEN COALESCE(CAST(( ( SUM(DISTINCT (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) + (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001 )) - SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001) )/(1*1.0)) as FLOAT64),0) END)*100000) as births_per_100k__1, CASE WHEN group_set=2 THEN names.decade END as decade__2, floor((CASE WHEN group_set=2 THEN COALESCE(SUM(by_name_0.population),0) END/CASE WHEN group_set=2 THEN COALESCE(CAST(( ( SUM(DISTINCT (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) + (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001 )) - SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001) )/(1*1.0)) as FLOAT64),0) END)*100000) as births_per_100k__2, CASE WHEN group_set=2 THEN names.baby_gender END as baby_gender__2 FROM (SELECT GENERATE_UUID() as __distinct_key, * FROM __stage1 as x) as names LEFT JOIN UNNEST(names.by_name) as by_name_0 CROSS JOIN (SELECT row_number() OVER() -1 group_set FROM UNNEST(GENERATE_ARRAY(0,2,1))) WHERE (concat(by_name_0.name,'')) LIKE 'Mich%' GROUP BY 1,2,4,6,8 ) SELECT name__0 as name, ANY_VALUE(CASE WHEN group_set=0 THEN total_population__0 END) as total_population, ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT( state__1 as state, births_per_100k__1 as births_per_100k ) END IGNORE NULLS ORDER BY births_per_100k__1 desc ) as state_map, ARRAY_AGG(CASE WHEN group_set=2 THEN STRUCT( decade__2 as decade, births_per_100k__2 as births_per_100k, baby_gender__2 as baby_gender ) END IGNORE NULLS ORDER BY births_per_100k__2 desc ) as decade_graph FROM __stage2 GROUP BY 1 ORDER BY 2 desc LIMIT 15
Iconic Names by State and Gender
Calculate the births per 100K for a name in general and a name within a state. Compute and sort by a ratio to figure out relative popularity.
query: names { where: decade < 1970 } -> { group_by: name group_by: gender aggregate: births_per_100k nest: by_state is { group_by: state aggregate: births_per_100k } } -> { where: births_per_100k > 50 group_by: by_state.state nest: by_gender is { group_by: gender nest: by_name is { top: 15 order_by: popularity desc group_by: name aggregate: popularity is (by_state.births_per_100k - births_per_100k) / births_per_100k } } }
| state | by_​gender |
|---|---|
| AK | gender F gender M |
| AL | gender F gender M |
| AR | gender F gender M |
| AZ | gender F gender M |
| CA | gender F gender M |
| CO | gender F gender M |
| CT | gender F gender M |
| DC | gender F gender M |
| DE | gender F gender M |
| FL | gender F gender M |
| GA | gender F gender M |
| HI | gender F gender M |
| IA | gender F gender M |
| ID | gender F gender M |
| IL | gender F gender M |
| IN | gender F gender M |
| KS | gender F gender M |
| KY | gender F gender M |
| LA | gender F gender M |
| MA | gender F gender M |
| MD | gender F gender M |
| ME | gender F gender M |
| MI | gender F gender M |
| MN | gender F gender M |
| MO | gender F gender M |
| MS | gender F gender M |
| MT | gender F gender M |
| NC | gender F gender M |
| ND | gender F gender M |
| NE | gender F gender M |
| NH | gender F gender M |
| NJ | gender F gender M |
| NM | gender F gender M |
| NV | gender F gender M |
| NY | gender F gender M |
| OH | gender F gender M |
| OK | gender F gender M |
| OR | gender F gender M |
| PA | gender F gender M |
| RI | gender F gender M |
| SC | gender F gender M |
| SD | gender F gender M |
| TN | gender F gender M |
| TX | gender F gender M |
| UT | gender F gender M |
| VA | gender F gender M |
| VT | gender F gender M |
| WA | gender F gender M |
| WI | gender F gender M |
| WV | gender F gender M |
| WY | gender F gender M |
[ { "state": "AK", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Daisy", "popularity": 5.228571428571429 }, { "name": "Shannon", "popularity": 2.5058823529411764 }, { "name": "Lucy", "popularity": 2.3893129770992365 }, { "name": "Sophie", "popularity": 1.9180327868852458 }, { "name": "Agnes", "popularity": 1.8523489932885906 }, { "name": "Tina", "popularity": 1.8458333333333334 }, { "name": "Deanna", "popularity": 1.841121495327103 }, { "name": "Katherine", "popularity": 1.7352941176470589 }, { "name": "Colleen", "popularity": 1.6524822695035462 }, { "name": "Kristin", "popularity": 1.5671641791044777 }, { "name": "Leslie", "popularity": 1.496969696969697 }, { "name": "Teresa", "popularity": 1.4666666666666666 }, { "name": "Heather", "popularity": 1.423529411764706 }, { "name": "Heidi", "popularity": 1.3636363636363635 }, { "name": "Valerie", "popularity": 1.360655737704918 } ] }, { "gender": "M", "by_name": [ { "name": "Shawn", "popularity": 3.152542372881356 }, { "name": "Jason", "popularity": 2.7083333333333335 }, { "name": "Troy", "popularity": 1.6666666666666667 }, { "name": "Tracy", "popularity": 1.6229508196721312 }, { "name": "Sean", "popularity": 1.6050420168067228 }, { "name": "Peter", "popularity": 1.5207877461706782 }, { "name": "Patrick", "popularity": 1.441860465116279 }, { "name": "Karl", "popularity": 1.4047619047619047 }, { "name": "Matthew", "popularity": 1.3108108108108107 }, { "name": "Dwayne", "popularity": 1.28125 }, { "name": "Darren", "popularity": 1.2371134020618557 }, { "name": "Eric", "popularity": 1.2032258064516128 }, { "name": "Mike", "popularity": 1.1478260869565218 }, { "name": "Andrew", "popularity": 1.1396648044692737 }, { "name": "Micheal", "popularity": 1.128 } ] } ] }, { "state": "AL", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Annie", "popularity": 4.750778816199377 }, { "name": "Willie", "popularity": 3.771573604060914 }, { "name": "Mattie", "popularity": 3.688888888888889 }, { "name": "Johnnie", "popularity": 3.3378378378378377 }, { "name": "Rosie", "popularity": 3.0344827586206895 }, { "name": "Shelia", "popularity": 2.9873417721518987 }, { "name": "Katie", "popularity": 2.9642857142857144 }, { "name": "Fannie", "popularity": 2.8395061728395063 }, { "name": "Lillie", "popularity": 2.704697986577181 }, { "name": "Essie", "popularity": 2.627450980392157 }, { "name": "Lula", "popularity": 2.5357142857142856 }, { "name": "Minnie", "popularity": 2.4122137404580153 }, { "name": "Hattie", "popularity": 2.3176470588235296 }, { "name": "Mamie", "popularity": 2.3013698630136985 }, { "name": "Susie", "popularity": 2.2987012987012987 } ] }, { "gender": "M", "by_name": [ { "name": "Willie", "popularity": 4.27348643006263 }, { "name": "Charlie", "popularity": 3.1188811188811187 }, { "name": "Roosevelt", "popularity": 2.823529411764706 }, { "name": "Earnest", "popularity": 2.6911764705882355 }, { "name": "Jessie", "popularity": 2.5757575757575757 }, { "name": "Johnnie", "popularity": 2.5535714285714284 }, { "name": "Rickey", "popularity": 2.3295454545454546 }, { "name": "Eddie", "popularity": 2.284263959390863 }, { "name": "Jimmie", "popularity": 2.24031007751938 }, { "name": "Horace", "popularity": 2.129032258064516 }, { "name": "Otis", "popularity": 2.1 }, { "name": "Jimmy", "popularity": 2.036363636363636 }, { "name": "Johnny", "popularity": 1.9124087591240877 }, { "name": "Billy", "popularity": 1.827930174563591 }, { "name": "Bennie", "popularity": 1.793103448275862 } ] } ] }, { "state": "AR", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Rosie", "popularity": 3.2298850574712645 }, { "name": "Bobbie", "popularity": 2.79 }, { "name": "Erma", "popularity": 2.772727272727273 }, { "name": "Patsy", "popularity": 2.5576923076923075 }, { "name": "Billie", "popularity": 2.4862385321100917 }, { "name": "Ruby", "popularity": 2.279503105590062 }, { "name": "Velma", "popularity": 2.2450980392156863 }, { "name": "Opal", "popularity": 2.216494845360825 }, { "name": "Ollie", "popularity": 2.196078431372549 }, { "name": "Geneva", "popularity": 2.163265306122449 }, { "name": "Willie", "popularity": 2.116751269035533 }, { "name": "Essie", "popularity": 1.9411764705882353 }, { "name": "Jessie", "popularity": 1.8828125 }, { "name": "Shelia", "popularity": 1.8481012658227849 }, { "name": "Lola", "popularity": 1.838235294117647 } ] }, { "gender": "M", "by_name": [ { "name": "Rickey", "popularity": 3.6363636363636362 }, { "name": "Billy", "popularity": 3.309226932668329 }, { "name": "Bobby", "popularity": 3.241590214067278 }, { "name": "Jimmy", "popularity": 2.890909090909091 }, { "name": "Jessie", "popularity": 2.4545454545454546 }, { "name": "Earnest", "popularity": 2.426470588235294 }, { "name": "Freddie", "popularity": 2.3205128205128207 }, { "name": "Tommy", "popularity": 2.280701754385965 }, { "name": "Jimmie", "popularity": 2.201550387596899 }, { "name": "Otis", "popularity": 2.15 }, { "name": "Jackie", "popularity": 2.1382978723404253 }, { "name": "Bennie", "popularity": 1.896551724137931 }, { "name": "Roosevelt", "popularity": 1.8823529411764706 }, { "name": "Luther", "popularity": 1.8208955223880596 }, { "name": "Cecil", "popularity": 1.7478260869565216 } ] } ] }, { "state": "AZ", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Carmen", "popularity": 5.6421052631578945 }, { "name": "Cecilia", "popularity": 3.719298245614035 }, { "name": "Maria", "popularity": 3.6487341772151898 }, { "name": "Lupe", "popularity": 3.2222222222222223 }, { "name": "Lydia", "popularity": 3.1973684210526314 }, { "name": "Yolanda", "popularity": 3 }, { "name": "Ramona", "popularity": 2.5555555555555554 }, { "name": "Dora", "popularity": 1.956043956043956 }, { "name": "Guadalupe", "popularity": 1.9111111111111112 }, { "name": "Susie", "popularity": 1.6103896103896105 }, { "name": "Alicia", "popularity": 1.606060606060606 }, { "name": "Veronica", "popularity": 1.5044247787610618 }, { "name": "Christina", "popularity": 1.4916666666666667 }, { "name": "Rosie", "popularity": 1.471264367816092 }, { "name": "Monica", "popularity": 1.3944954128440368 } ] }, { "gender": "M", "by_name": [ { "name": "Manuel", "popularity": 8.99090909090909 }, { "name": "Ruben", "popularity": 5.639344262295082 }, { "name": "Francisco", "popularity": 5 }, { "name": "Carlos", "popularity": 4.417721518987341 }, { "name": "Jesus", "popularity": 4.323529411764706 }, { "name": "Jose", "popularity": 3.603864734299517 }, { "name": "Gilbert", "popularity": 3.4796747967479673 }, { "name": "Antonio", "popularity": 3.4761904761904763 }, { "name": "Raul", "popularity": 3.1449275362318843 }, { "name": "Alex", "popularity": 3.078125 }, { "name": "Hector", "popularity": 2.9622641509433962 }, { "name": "Miguel", "popularity": 2.7037037037037037 }, { "name": "Juan", "popularity": 2.456692913385827 }, { "name": "Luis", "popularity": 2.364705882352941 }, { "name": "Woodrow", "popularity": 2.0576923076923075 } ] } ] }, { "state": "CA", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Christina", "popularity": 1.3583333333333334 }, { "name": "Carmen", "popularity": 1.3473684210526315 }, { "name": "Yolanda", "popularity": 1.2571428571428571 }, { "name": "Teri", "popularity": 1.0597014925373134 }, { "name": "Maria", "popularity": 1.009493670886076 }, { "name": "Pat", "popularity": 0.9074074074074074 }, { "name": "Cecilia", "popularity": 0.8771929824561403 }, { "name": "Leslie", "popularity": 0.8484848484848485 }, { "name": "Julie", "popularity": 0.8373333333333334 }, { "name": "Victoria", "popularity": 0.8285714285714286 }, { "name": "Monica", "popularity": 0.7798165137614679 }, { "name": "Ramona", "popularity": 0.7638888888888888 }, { "name": "Alicia", "popularity": 0.7272727272727273 }, { "name": "Lydia", "popularity": 0.7236842105263158 }, { "name": "Shannon", "popularity": 0.7176470588235294 } ] }, { "gender": "M", "by_name": [ { "name": "Manuel", "popularity": 2.327272727272727 }, { "name": "Ruben", "popularity": 2 }, { "name": "Carlos", "popularity": 1.4683544303797469 }, { "name": "Mario", "popularity": 1.2307692307692308 }, { "name": "Mike", "popularity": 1.1956521739130435 }, { "name": "Jason", "popularity": 1.0694444444444444 }, { "name": "Bob", "popularity": 1.0357142857142858 }, { "name": "Lance", "popularity": 0.9821428571428571 }, { "name": "Gilbert", "popularity": 0.967479674796748 }, { "name": "Jim", "popularity": 0.9651162790697675 }, { "name": "Dave", "popularity": 0.9104477611940298 }, { "name": "Ricardo", "popularity": 0.8727272727272727 }, { "name": "Jose", "popularity": 0.8599033816425121 }, { "name": "Eric", "popularity": 0.8290322580645161 }, { "name": "Chris", "popularity": 0.824 } ] } ] }, { "state": "CO", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Kristi", "popularity": 1.9615384615384615 }, { "name": "Shelly", "popularity": 1.3904761904761904 }, { "name": "Olive", "popularity": 1.2692307692307692 }, { "name": "Bernadette", "popularity": 1.2105263157894737 }, { "name": "Ramona", "popularity": 1.1944444444444444 }, { "name": "Becky", "popularity": 1.1009174311926606 }, { "name": "Nicole", "popularity": 1.0909090909090908 }, { "name": "Heather", "popularity": 1.0705882352941176 }, { "name": "Della", "popularity": 1.0526315789473684 }, { "name": "Heidi", "popularity": 1.0303030303030303 }, { "name": "Erma", "popularity": 1.0151515151515151 }, { "name": "Dianna", "popularity": 1.0147058823529411 }, { "name": "Karla", "popularity": 0.9682539682539683 }, { "name": "Kelli", "popularity": 0.9636363636363636 }, { "name": "Shannon", "popularity": 0.9176470588235294 } ] }, { "gender": "M", "by_name": [ { "name": "Kent", "popularity": 1.943661971830986 }, { "name": "Manuel", "popularity": 1.6454545454545455 }, { "name": "Kirk", "popularity": 1.6056338028169015 }, { "name": "Woodrow", "popularity": 1.5576923076923077 }, { "name": "Gilbert", "popularity": 1.3739837398373984 }, { "name": "Kelly", "popularity": 1.3333333333333333 }, { "name": "Brett", "popularity": 1.2876712328767124 }, { "name": "Bob", "popularity": 1.2053571428571428 }, { "name": "Shawn", "popularity": 1.11864406779661 }, { "name": "Delbert", "popularity": 1.1090909090909091 }, { "name": "Rick", "popularity": 1.104 }, { "name": "Mike", "popularity": 1.0739130434782609 }, { "name": "Jason", "popularity": 1.0277777777777777 }, { "name": "Dave", "popularity": 1 }, { "name": "Joe", "popularity": 0.9848484848484849 } ] } ] }, { "state": "CT", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Sophie", "popularity": 2.6557377049180326 }, { "name": "Doreen", "popularity": 2.646153846153846 }, { "name": "Claire", "popularity": 1.7721518987341771 }, { "name": "Lynn", "popularity": 1.663716814159292 }, { "name": "Gail", "popularity": 1.5643939393939394 }, { "name": "Antoinette", "popularity": 1.5128205128205128 }, { "name": "Kristen", "popularity": 1.509433962264151 }, { "name": "Maureen", "popularity": 1.4767441860465116 }, { "name": "Maryann", "popularity": 1.4605263157894737 }, { "name": "Laurie", "popularity": 1.4080717488789238 }, { "name": "Marion", "popularity": 1.3429951690821256 }, { "name": "Jennie", "popularity": 1.2577319587628866 }, { "name": "Heather", "popularity": 1.188235294117647 }, { "name": "Anne", "popularity": 1.1428571428571428 }, { "name": "Heidi", "popularity": 1.101010101010101 } ] }, { "gender": "M", "by_name": [ { "name": "Peter", "popularity": 2.448577680525164 }, { "name": "Nicholas", "popularity": 1.983739837398374 }, { "name": "Salvatore", "popularity": 1.9 }, { "name": "Jonathan", "popularity": 1.7372881355932204 }, { "name": "Angelo", "popularity": 1.6428571428571428 }, { "name": "Francis", "popularity": 1.4749163879598661 }, { "name": "Alexander", "popularity": 1.3529411764705883 }, { "name": "Vincent", "popularity": 1.269406392694064 }, { "name": "Marc", "popularity": 1.1714285714285715 }, { "name": "Sean", "popularity": 1.1680672268907564 }, { "name": "Frederick", "popularity": 1.1526104417670682 }, { "name": "Anthony", "popularity": 1.0221238938053097 }, { "name": "Louis", "popularity": 0.9655172413793104 }, { "name": "Joseph", "popularity": 0.9080841638981174 }, { "name": "Theodore", "popularity": 0.841025641025641 } ] } ] }, { "state": "DC", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Cassandra", "popularity": 2.0185185185185186 }, { "name": "Crystal", "popularity": 2.0172413793103448 }, { "name": "Yvette", "popularity": 1.8666666666666667 }, { "name": "Tonya", "popularity": 1.8333333333333333 }, { "name": "Tanya", "popularity": 1.71875 }, { "name": "Gwendolyn", "popularity": 1.5508474576271187 }, { "name": "Leslie", "popularity": 1.4 }, { "name": "Jacqueline", "popularity": 1.3650793650793651 }, { "name": "Delores", "popularity": 1.3310810810810811 }, { "name": "Laverne", "popularity": 1.3272727272727274 }, { "name": "Renee", "popularity": 1.31875 }, { "name": "Vanessa", "popularity": 1.316326530612245 }, { "name": "Nicole", "popularity": 1.290909090909091 }, { "name": "Monica", "popularity": 1.2660550458715596 }, { "name": "Yvonne", "popularity": 1.2531645569620253 } ] }, { "gender": "M", "by_name": [ { "name": "Tyrone", "popularity": 5.2631578947368425 }, { "name": "Reginald", "popularity": 3.7848101265822787 }, { "name": "Derrick", "popularity": 2.626865671641791 }, { "name": "Maurice", "popularity": 1.9081632653061225 }, { "name": "Ricardo", "popularity": 1.7636363636363637 }, { "name": "Darryl", "popularity": 1.693069306930693 }, { "name": "Dwayne", "popularity": 1.6875 }, { "name": "Derek", "popularity": 1.6851851851851851 }, { "name": "Nathaniel", "popularity": 1.4166666666666667 }, { "name": "Jonathan", "popularity": 1.3305084745762712 }, { "name": "Sean", "popularity": 1.2605042016806722 }, { "name": "Eric", "popularity": 1.2193548387096773 }, { "name": "Clifton", "popularity": 1.1666666666666667 }, { "name": "Bernard", "popularity": 1.0934579439252337 }, { "name": "Christopher", "popularity": 1 } ] } ] }, { "state": "DE", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Crystal", "popularity": 3.396551724137931 }, { "name": "Sophie", "popularity": 2.8688524590163933 }, { "name": "Mabel", "popularity": 2.5784313725490198 }, { "name": "Stella", "popularity": 2.3389830508474576 }, { "name": "Hilda", "popularity": 2.325301204819277 }, { "name": "Heather", "popularity": 2.1294117647058823 }, { "name": "Elsie", "popularity": 2.096969696969697 }, { "name": "Pearl", "popularity": 1.8387096774193548 }, { "name": "Nicole", "popularity": 1.8363636363636364 }, { "name": "Agnes", "popularity": 1.6979865771812082 }, { "name": "Holly", "popularity": 1.588785046728972 }, { "name": "Kristin", "popularity": 1.5820895522388059 }, { "name": "Dawn", "popularity": 1.5193798449612403 }, { "name": "Olive", "popularity": 1.5192307692307692 }, { "name": "Blanche", "popularity": 1.4487179487179487 } ] }, { "gender": "M", "by_name": [ { "name": "Woodrow", "popularity": 3.980769230769231 }, { "name": "Francis", "popularity": 2.3812709030100336 }, { "name": "Sean", "popularity": 1.4789915966386555 }, { "name": "Matthew", "popularity": 1.2567567567567568 }, { "name": "Tyrone", "popularity": 1.2456140350877194 }, { "name": "Harry", "popularity": 1.2115384615384615 }, { "name": "Roland", "popularity": 1.168421052631579 }, { "name": "Christopher", "popularity": 1.1674008810572687 }, { "name": "Franklin", "popularity": 1.139344262295082 }, { "name": "Dwayne", "popularity": 1.0625 }, { "name": "Horace", "popularity": 1.0483870967741935 }, { "name": "Willard", "popularity": 1.0470588235294118 }, { "name": "Wayne", "popularity": 1.0395778364116095 }, { "name": "Bryan", "popularity": 1.0341880341880343 }, { "name": "Jonathan", "popularity": 0.9067796610169492 } ] } ] }, { "state": "FL", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Cassandra", "popularity": 1.7037037037037037 }, { "name": "Gwendolyn", "popularity": 1.5254237288135593 }, { "name": "Jacquelyn", "popularity": 1.323076923076923 }, { "name": "Rosa", "popularity": 1.0431654676258992 }, { "name": "Essie", "popularity": 0.9803921568627451 }, { "name": "Belinda", "popularity": 0.967032967032967 }, { "name": "Ernestine", "popularity": 0.9090909090909091 }, { "name": "Annie", "popularity": 0.8660436137071651 }, { "name": "Iris", "popularity": 0.8392857142857143 }, { "name": "Tina", "popularity": 0.8291666666666667 }, { "name": "Daisy", "popularity": 0.8285714285714286 }, { "name": "Johnnie", "popularity": 0.8243243243243243 }, { "name": "Angela", "popularity": 0.8207547169811321 }, { "name": "Willie", "popularity": 0.7715736040609137 }, { "name": "Inez", "popularity": 0.7428571428571429 } ] }, { "gender": "M", "by_name": [ { "name": "Nathaniel", "popularity": 2.236111111111111 }, { "name": "Freddie", "popularity": 1.7435897435897436 }, { "name": "Willie", "popularity": 1.7160751565762005 }, { "name": "Johnnie", "popularity": 1.4375 }, { "name": "Reginald", "popularity": 1.3670886075949367 }, { "name": "Roosevelt", "popularity": 1.2352941176470589 }, { "name": "Horace", "popularity": 1.1774193548387097 }, { "name": "Eddie", "popularity": 1.0964467005076142 }, { "name": "Charlie", "popularity": 0.9020979020979021 }, { "name": "Derrick", "popularity": 0.8955223880597015 }, { "name": "Jimmie", "popularity": 0.8449612403100775 }, { "name": "Johnny", "popularity": 0.843065693430657 }, { "name": "Dwayne", "popularity": 0.765625 }, { "name": "Tyrone", "popularity": 0.7543859649122807 }, { "name": "Earnest", "popularity": 0.75 } ] } ] }, { "state": "GA", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Annie", "popularity": 3.9968847352024923 }, { "name": "Mattie", "popularity": 3.762962962962963 }, { "name": "Willie", "popularity": 3.1776649746192893 }, { "name": "Essie", "popularity": 3.0980392156862746 }, { "name": "Mamie", "popularity": 3.0273972602739727 }, { "name": "Johnnie", "popularity": 2.72972972972973 }, { "name": "Susie", "popularity": 2.4935064935064934 }, { "name": "Fannie", "popularity": 2.4444444444444446 }, { "name": "Lillie", "popularity": 2.4093959731543624 }, { "name": "Hattie", "popularity": 2.2823529411764705 }, { "name": "Katie", "popularity": 2.25 }, { "name": "Sara", "popularity": 2.183006535947712 }, { "name": "Rosa", "popularity": 2.172661870503597 }, { "name": "Daisy", "popularity": 2.0714285714285716 }, { "name": "Lucile", "popularity": 2.0677966101694913 } ] }, { "gender": "M", "by_name": [ { "name": "Charlie", "popularity": 4.636363636363637 }, { "name": "Willie", "popularity": 4.569937369519833 }, { "name": "Horace", "popularity": 3.0806451612903225 }, { "name": "Otis", "popularity": 2.7333333333333334 }, { "name": "Bennie", "popularity": 2.4827586206896552 }, { "name": "Johnnie", "popularity": 2.4375 }, { "name": "Eddie", "popularity": 2.3908629441624365 }, { "name": "Freddie", "popularity": 2.1153846153846154 }, { "name": "Nathaniel", "popularity": 2.0833333333333335 }, { "name": "Earnest", "popularity": 2.073529411764706 }, { "name": "Johnny", "popularity": 2.0437956204379564 }, { "name": "Marion", "popularity": 1.8125 }, { "name": "Roosevelt", "popularity": 1.803921568627451 }, { "name": "Hugh", "popularity": 1.7721518987341771 }, { "name": "Hubert", "popularity": 1.7692307692307692 } ] } ] }, { "state": "HI", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Kiyoko", "popularity": 6.7894736842105265 }, { "name": "Yoshiko", "popularity": 6.393258426966292 }, { "name": "Masako", "popularity": 5.983606557377049 }, { "name": "Fumiko", "popularity": 5.910714285714286 }, { "name": "Mitsue", "popularity": 5.867924528301887 }, { "name": "Shizue", "popularity": 4.775280898876405 }, { "name": "Roxanne", "popularity": 4.723076923076923 }, { "name": "Bernadette", "popularity": 4.578947368421052 }, { "name": "Yoshie", "popularity": 4.026666666666666 }, { "name": "Shizuko", "popularity": 3.9753086419753085 }, { "name": "Kikue", "popularity": 3.9655172413793105 }, { "name": "Iris", "popularity": 3.9107142857142856 }, { "name": "Mitsuko", "popularity": 3.8875 }, { "name": "Violet", "popularity": 3.6320754716981134 }, { "name": "Doreen", "popularity": 3.4153846153846152 } ] }, { "gender": "M", "by_name": [ { "name": "Toshio", "popularity": 7.901960784313726 }, { "name": "Yoshio", "popularity": 7.884615384615385 }, { "name": "Kiyoshi", "popularity": 6.985074626865671 }, { "name": "Kazuo", "popularity": 6.425925925925926 }, { "name": "Lance", "popularity": 6.089285714285714 }, { "name": "Minoru", "popularity": 5.980769230769231 }, { "name": "Derek", "popularity": 5.833333333333333 }, { "name": "Takeo", "popularity": 4.9411764705882355 }, { "name": "Jason", "popularity": 4.791666666666667 }, { "name": "Clayton", "popularity": 4.372881355932203 }, { "name": "Shigeo", "popularity": 4.311475409836065 }, { "name": "Nathan", "popularity": 3.967741935483871 }, { "name": "Guy", "popularity": 3.588235294117647 }, { "name": "Wendell", "popularity": 3.207547169811321 }, { "name": "Sean", "popularity": 3.092436974789916 } ] } ] }, { "state": "IA", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Becky", "popularity": 1.926605504587156 }, { "name": "Karla", "popularity": 1.9206349206349207 }, { "name": "Shelly", "popularity": 1.8476190476190477 }, { "name": "Maxine", "popularity": 1.8257575757575757 }, { "name": "Kristi", "popularity": 1.5769230769230769 }, { "name": "Julie", "popularity": 1.5226666666666666 }, { "name": "Jodi", "popularity": 1.4431818181818181 }, { "name": "Sheryl", "popularity": 1.403225806451613 }, { "name": "Marcella", "popularity": 1.3387096774193548 }, { "name": "Connie", "popularity": 1.3268608414239482 }, { "name": "Tami", "popularity": 1.3015873015873016 }, { "name": "Erma", "popularity": 1.2878787878787878 }, { "name": "Jody", "popularity": 1.2686567164179106 }, { "name": "Kristine", "popularity": 1.2272727272727273 }, { "name": "Roxanne", "popularity": 1.1076923076923078 } ] }, { "gender": "M", "by_name": [ { "name": "Lyle", "popularity": 3.761904761904762 }, { "name": "Duane", "popularity": 2.5080645161290325 }, { "name": "Kent", "popularity": 2.112676056338028 }, { "name": "Dean", "popularity": 2.0961538461538463 }, { "name": "Woodrow", "popularity": 1.7884615384615385 }, { "name": "Darin", "popularity": 1.7735849056603774 }, { "name": "Max", "popularity": 1.6849315068493151 }, { "name": "Bradley", "popularity": 1.6097560975609757 }, { "name": "Rick", "popularity": 1.584 }, { "name": "Delbert", "popularity": 1.5636363636363637 }, { "name": "Virgil", "popularity": 1.4871794871794872 }, { "name": "Dale", "popularity": 1.4707792207792207 }, { "name": "Lynn", "popularity": 1.45 }, { "name": "Jon", "popularity": 1.4413793103448276 }, { "name": "Rex", "popularity": 1.4385964912280702 } ] } ] }, { "state": "ID", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Olive", "popularity": 3.8076923076923075 }, { "name": "Karla", "popularity": 3.2063492063492065 }, { "name": "Heather", "popularity": 2.929411764705882 }, { "name": "Shannon", "popularity": 2.8117647058823527 }, { "name": "Shelley", "popularity": 2.730337078651685 }, { "name": "Kristi", "popularity": 2.5576923076923075 }, { "name": "Maxine", "popularity": 2.5303030303030303 }, { "name": "Becky", "popularity": 2.467889908256881 }, { "name": "Blanche", "popularity": 2.358974358974359 }, { "name": "Tamara", "popularity": 2.3423423423423424 }, { "name": "Robyn", "popularity": 2.169811320754717 }, { "name": "Tami", "popularity": 2.1587301587301586 }, { "name": "Jody", "popularity": 2.1194029850746268 }, { "name": "Opal", "popularity": 2.0927835051546393 }, { "name": "Shelly", "popularity": 2.0476190476190474 } ] }, { "gender": "M", "by_name": [ { "name": "Kelly", "popularity": 5.944444444444445 }, { "name": "Brent", "popularity": 5.597560975609756 }, { "name": "Darin", "popularity": 5.452830188679245 }, { "name": "Lynn", "popularity": 5.2 }, { "name": "Woodrow", "popularity": 4.230769230769231 }, { "name": "Kim", "popularity": 3.8793103448275863 }, { "name": "Kent", "popularity": 3.788732394366197 }, { "name": "Lyle", "popularity": 3.4126984126984126 }, { "name": "Rex", "popularity": 3.3684210526315788 }, { "name": "Max", "popularity": 2.9726027397260273 }, { "name": "Tracy", "popularity": 2.80327868852459 }, { "name": "Brett", "popularity": 2.493150684931507 }, { "name": "Brad", "popularity": 2.4615384615384617 }, { "name": "Delbert", "popularity": 2.4 }, { "name": "Rick", "popularity": 2.264 } ] } ] }, { "state": "IL", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Laverne", "popularity": 1.2727272727272727 }, { "name": "Dolores", "popularity": 0.6666666666666666 }, { "name": "Rosemary", "popularity": 0.611764705882353 }, { "name": "Lorraine", "popularity": 0.6056910569105691 }, { "name": "Genevieve", "popularity": 0.6043956043956044 }, { "name": "Marcella", "popularity": 0.5806451612903226 }, { "name": "Pat", "popularity": 0.5555555555555556 }, { "name": "Marianne", "popularity": 0.5 }, { "name": "Marilyn", "popularity": 0.45879732739420936 }, { "name": "Judith", "popularity": 0.41637010676156583 }, { "name": "Loretta", "popularity": 0.38341968911917096 }, { "name": "Arlene", "popularity": 0.37037037037037035 }, { "name": "Eileen", "popularity": 0.35436893203883496 }, { "name": "Bernice", "popularity": 0.34782608695652173 }, { "name": "Kristine", "popularity": 0.32954545454545453 } ] }, { "gender": "M", "by_name": [ { "name": "Jerome", "popularity": 0.6040268456375839 }, { "name": "Derrick", "popularity": 0.5373134328358209 }, { "name": "Tyrone", "popularity": 0.47368421052631576 }, { "name": "Maurice", "popularity": 0.42857142857142855 }, { "name": "Bradley", "popularity": 0.36585365853658536 }, { "name": "Tom", "popularity": 0.3355263157894737 }, { "name": "Lyle", "popularity": 0.3333333333333333 }, { "name": "Brad", "popularity": 0.2948717948717949 }, { "name": "Chester", "popularity": 0.2734375 }, { "name": "Patrick", "popularity": 0.26356589147286824 }, { "name": "Kurt", "popularity": 0.2558139534883721 }, { "name": "Lawrence", "popularity": 0.2521186440677966 }, { "name": "Bob", "popularity": 0.25 }, { "name": "Martin", "popularity": 0.24796747967479674 }, { "name": "Darryl", "popularity": 0.24752475247524752 } ] } ] }, { "state": "IN", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Tamara", "popularity": 1.3513513513513513 }, { "name": "Patty", "popularity": 1.1927710843373494 }, { "name": "Tina", "popularity": 1.1458333333333333 }, { "name": "Wilma", "popularity": 1.0172413793103448 }, { "name": "Penny", "popularity": 0.968503937007874 }, { "name": "Beth", "popularity": 0.959731543624161 }, { "name": "Marsha", "popularity": 0.952054794520548 }, { "name": "Olive", "popularity": 0.9423076923076923 }, { "name": "Sue", "popularity": 0.9367816091954023 }, { "name": "Lana", "popularity": 0.9215686274509803 }, { "name": "Dianna", "popularity": 0.9117647058823529 }, { "name": "Becky", "popularity": 0.8256880733944955 }, { "name": "Tonya", "popularity": 0.8222222222222222 }, { "name": "Marcia", "popularity": 0.8141025641025641 }, { "name": "Rebecca", "popularity": 0.7552083333333334 } ] }, { "gender": "M", "by_name": [ { "name": "Max", "popularity": 2.3698630136986303 }, { "name": "Rex", "popularity": 1.9298245614035088 }, { "name": "Kent", "popularity": 1.3380281690140845 }, { "name": "Rick", "popularity": 1.28 }, { "name": "Brent", "popularity": 1.1341463414634145 }, { "name": "Bradley", "popularity": 1.032520325203252 }, { "name": "Jeffery", "popularity": 0.9669421487603306 }, { "name": "Jeff", "popularity": 0.9536423841059603 }, { "name": "Tim", "popularity": 0.9459459459459459 }, { "name": "Wilbur", "popularity": 0.9047619047619048 }, { "name": "Darrin", "popularity": 0.8846153846153846 }, { "name": "Kerry", "popularity": 0.8793103448275862 }, { "name": "Darin", "popularity": 0.8679245283018868 }, { "name": "Garry", "popularity": 0.8333333333333334 }, { "name": "Terry", "popularity": 0.7539149888143176 } ] } ] }, { "state": "KS", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Karla", "popularity": 2.111111111111111 }, { "name": "Kristi", "popularity": 1.9230769230769231 }, { "name": "Shelly", "popularity": 1.819047619047619 }, { "name": "Maxine", "popularity": 1.8106060606060606 }, { "name": "Wilma", "popularity": 1.7298850574712643 }, { "name": "Opal", "popularity": 1.556701030927835 }, { "name": "Deanna", "popularity": 1.4485981308411215 }, { "name": "Connie", "popularity": 1.4142394822006472 }, { "name": "Velma", "popularity": 1.392156862745098 }, { "name": "Lana", "popularity": 1.3725490196078431 }, { "name": "Lola", "popularity": 1.2941176470588236 }, { "name": "Dana", "popularity": 1.2589285714285714 }, { "name": "Beulah", "popularity": 1.2325581395348837 }, { "name": "Dianna", "popularity": 1.2205882352941178 }, { "name": "Sheryl", "popularity": 1.2016129032258065 } ] }, { "gender": "M", "by_name": [ { "name": "Darin", "popularity": 3.5283018867924527 }, { "name": "Max", "popularity": 2.452054794520548 }, { "name": "Rex", "popularity": 2.280701754385965 }, { "name": "Delbert", "popularity": 2.2 }, { "name": "Kelly", "popularity": 2.1666666666666665 }, { "name": "Virgil", "popularity": 2.0128205128205128 }, { "name": "Lyle", "popularity": 1.9841269841269842 }, { "name": "Kent", "popularity": 1.8732394366197183 }, { "name": "Bradley", "popularity": 1.6341463414634145 }, { "name": "Brad", "popularity": 1.5256410256410255 }, { "name": "Bob", "popularity": 1.375 }, { "name": "Brent", "popularity": 1.329268292682927 }, { "name": "Duane", "popularity": 1.2338709677419355 }, { "name": "Everett", "popularity": 1.2307692307692308 }, { "name": "Marion", "popularity": 1.2125 } ] } ] }, { "state": "KY", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Geneva", "popularity": 2.826530612244898 }, { "name": "Della", "popularity": 2.0701754385964914 }, { "name": "Opal", "popularity": 1.9690721649484537 }, { "name": "Shelia", "popularity": 1.7974683544303798 }, { "name": "Wilma", "popularity": 1.7586206896551724 }, { "name": "Beulah", "popularity": 1.6162790697674418 }, { "name": "Ruby", "popularity": 1.4720496894409938 }, { "name": "Wanda", "popularity": 1.4252199413489737 }, { "name": "Vickie", "popularity": 1.3571428571428572 }, { "name": "Ada", "popularity": 1.3478260869565217 }, { "name": "Alma", "popularity": 1.2733812949640289 }, { "name": "Nora", "popularity": 1.2 }, { "name": "Myrtle", "popularity": 1.1825396825396826 }, { "name": "Thelma", "popularity": 1.102661596958175 }, { "name": "Eula", "popularity": 1.096774193548387 } ] }, { "gender": "M", "by_name": [ { "name": "Donnie", "popularity": 3.343283582089552 }, { "name": "Jackie", "popularity": 2.25531914893617 }, { "name": "Wendell", "popularity": 1.7924528301886793 }, { "name": "Homer", "popularity": 1.7285714285714286 }, { "name": "Virgil", "popularity": 1.7179487179487178 }, { "name": "Cecil", "popularity": 1.6869565217391305 }, { "name": "Ronnie", "popularity": 1.6462264150943395 }, { "name": "Bobby", "popularity": 1.5963302752293578 }, { "name": "Billy", "popularity": 1.5960099750623442 }, { "name": "Hubert", "popularity": 1.5384615384615385 }, { "name": "Garry", "popularity": 1.5 }, { "name": "Everett", "popularity": 1.4615384615384615 }, { "name": "Danny", "popularity": 1.3678571428571429 }, { "name": "Willard", "popularity": 1.3647058823529412 }, { "name": "Luther", "popularity": 1.328358208955224 } ] } ] }, { "state": "LA", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Shelia", "popularity": 2.5822784810126582 }, { "name": "Irma", "popularity": 1.8243243243243243 }, { "name": "Eula", "popularity": 1.7580645161290323 }, { "name": "Rosie", "popularity": 1.7126436781609196 }, { "name": "Vanessa", "popularity": 1.663265306122449 }, { "name": "Gwendolyn", "popularity": 1.61864406779661 }, { "name": "Mable", "popularity": 1.5806451612903225 }, { "name": "Lillie", "popularity": 1.429530201342282 }, { "name": "Hilda", "popularity": 1.3734939759036144 }, { "name": "Bobbie", "popularity": 1.31 }, { "name": "Glenda", "popularity": 1.3055555555555556 }, { "name": "Ella", "popularity": 1.3021582733812949 }, { "name": "Willie", "popularity": 1.284263959390863 }, { "name": "Cassandra", "popularity": 1.2407407407407407 }, { "name": "Paulette", "popularity": 1.2173913043478262 } ] }, { "gender": "M", "by_name": [ { "name": "Sidney", "popularity": 2.3846153846153846 }, { "name": "Clifton", "popularity": 2.25 }, { "name": "Freddie", "popularity": 2.230769230769231 }, { "name": "Alvin", "popularity": 2.0714285714285716 }, { "name": "Roosevelt", "popularity": 1.9803921568627452 }, { "name": "Jessie", "popularity": 1.9090909090909092 }, { "name": "Dwayne", "popularity": 1.71875 }, { "name": "Willie", "popularity": 1.6346555323590815 }, { "name": "Tyrone", "popularity": 1.4912280701754386 }, { "name": "Oliver", "popularity": 1.4901960784313726 }, { "name": "Kerry", "popularity": 1.4655172413793103 }, { "name": "Herman", "popularity": 1.4295774647887325 }, { "name": "Earnest", "popularity": 1.411764705882353 }, { "name": "Calvin", "popularity": 1.401360544217687 }, { "name": "Byron", "popularity": 1.3584905660377358 } ] } ] }, { "state": "MA", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Claire", "popularity": 5.012658227848101 }, { "name": "Maureen", "popularity": 3.052325581395349 }, { "name": "Priscilla", "popularity": 2.2875 }, { "name": "Lynne", "popularity": 1.826086956521739 }, { "name": "Jeannette", "popularity": 1.7794117647058822 }, { "name": "Anne", "popularity": 1.584717607973422 }, { "name": "Joanne", "popularity": 1.5236220472440944 }, { "name": "Doreen", "popularity": 1.476923076923077 }, { "name": "Eleanor", "popularity": 1.475177304964539 }, { "name": "Muriel", "popularity": 1.4179104477611941 }, { "name": "Sophie", "popularity": 1.3934426229508197 }, { "name": "Marion", "popularity": 1.2946859903381642 }, { "name": "Eileen", "popularity": 1.2815533980582525 }, { "name": "Jeanne", "popularity": 1.2774869109947644 }, { "name": "Lorraine", "popularity": 1.2357723577235773 } ] }, { "gender": "M", "by_name": [ { "name": "Francis", "popularity": 2.842809364548495 }, { "name": "Peter", "popularity": 2.0568927789934355 }, { "name": "Gerard", "popularity": 2.013888888888889 }, { "name": "Dana", "popularity": 1.8703703703703705 }, { "name": "Roland", "popularity": 1.6421052631578947 }, { "name": "Leo", "popularity": 1.5030674846625767 }, { "name": "Frederick", "popularity": 1.2811244979919678 }, { "name": "Stephen", "popularity": 1.2660550458715596 }, { "name": "Philip", "popularity": 1.186206896551724 }, { "name": "Paul", "popularity": 1.179289026275116 }, { "name": "Jonathan", "popularity": 1.1440677966101696 }, { "name": "Alfred", "popularity": 1.0278884462151394 }, { "name": "Sean", "popularity": 0.9663865546218487 }, { "name": "Arthur", "popularity": 0.9026717557251909 }, { "name": "Joseph", "popularity": 0.8560354374307863 } ] } ] }, { "state": "MD", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Crystal", "popularity": 1.6379310344827587 }, { "name": "Hilda", "popularity": 1.3253012048192772 }, { "name": "Vanessa", "popularity": 1.3061224489795917 }, { "name": "Yvette", "popularity": 1.2166666666666666 }, { "name": "Robin", "popularity": 1.0163934426229508 }, { "name": "Rosalie", "popularity": 0.8873239436619719 }, { "name": "Darlene", "popularity": 0.8846153846153846 }, { "name": "Bernadette", "popularity": 0.8245614035087719 }, { "name": "Dawn", "popularity": 0.813953488372093 }, { "name": "Terry", "popularity": 0.803030303030303 }, { "name": "Catherine", "popularity": 0.8010471204188482 }, { "name": "Tracey", "popularity": 0.7606837606837606 }, { "name": "Naomi", "popularity": 0.75 }, { "name": "Regina", "popularity": 0.75 }, { "name": "Michele", "popularity": 0.7490774907749077 } ] }, { "gender": "M", "by_name": [ { "name": "Tyrone", "popularity": 2.0701754385964914 }, { "name": "Dwayne", "popularity": 1.484375 }, { "name": "Roland", "popularity": 1.2210526315789474 }, { "name": "Reginald", "popularity": 1.1265822784810127 }, { "name": "Clifton", "popularity": 1.1166666666666667 }, { "name": "Bernard", "popularity": 1.0700934579439252 }, { "name": "Maurice", "popularity": 0.9693877551020408 }, { "name": "Franklin", "popularity": 0.8688524590163934 }, { "name": "Melvin", "popularity": 0.8611111111111112 }, { "name": "Milton", "popularity": 0.859504132231405 }, { "name": "Vernon", "popularity": 0.8397435897435898 }, { "name": "Jerome", "popularity": 0.8322147651006712 }, { "name": "Harry", "popularity": 0.8028846153846154 }, { "name": "Nelson", "popularity": 0.7321428571428571 }, { "name": "Darrin", "popularity": 0.7307692307692307 } ] } ] }, { "state": "ME", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Priscilla", "popularity": 4.3 }, { "name": "Jeannette", "popularity": 3.6323529411764706 }, { "name": "Muriel", "popularity": 3.3134328358208953 }, { "name": "Olive", "popularity": 2.6538461538461537 }, { "name": "Claire", "popularity": 2.5063291139240507 }, { "name": "Constance", "popularity": 2.3051948051948052 }, { "name": "Pauline", "popularity": 2.2650602409638556 }, { "name": "Madeline", "popularity": 2.066666666666667 }, { "name": "Laurie", "popularity": 1.937219730941704 }, { "name": "Rachel", "popularity": 1.85 }, { "name": "Debora", "popularity": 1.6666666666666667 }, { "name": "Marguerite", "popularity": 1.631578947368421 }, { "name": "Kristen", "popularity": 1.6226415094339623 }, { "name": "Heidi", "popularity": 1.5757575757575757 }, { "name": "Tina", "popularity": 1.5291666666666666 } ] }, { "gender": "M", "by_name": [ { "name": "Dana", "popularity": 7.277777777777778 }, { "name": "Roland", "popularity": 6.515789473684211 }, { "name": "Woodrow", "popularity": 4.3076923076923075 }, { "name": "Gerard", "popularity": 3.7222222222222223 }, { "name": "Maurice", "popularity": 3.63265306122449 }, { "name": "Clayton", "popularity": 2.864406779661017 }, { "name": "Reginald", "popularity": 2.6202531645569622 }, { "name": "Everett", "popularity": 2.358974358974359 }, { "name": "Troy", "popularity": 2.1333333333333333 }, { "name": "Philip", "popularity": 2.010344827586207 }, { "name": "Adam", "popularity": 1.962962962962963 }, { "name": "Normand", "popularity": 1.8518518518518519 }, { "name": "Marc", "popularity": 1.7142857142857142 }, { "name": "Leo", "popularity": 1.6932515337423313 }, { "name": "Shawn", "popularity": 1.61864406779661 } ] } ] }, { "state": "MI", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Sally", "popularity": 0.76 }, { "name": "Dawn", "popularity": 0.7403100775193798 }, { "name": "Colleen", "popularity": 0.6524822695035462 }, { "name": "Sue", "popularity": 0.6264367816091954 }, { "name": "Julie", "popularity": 0.616 }, { "name": "Marcia", "popularity": 0.6025641025641025 }, { "name": "Kay", "popularity": 0.5785123966942148 }, { "name": "Genevieve", "popularity": 0.5604395604395604 }, { "name": "Kelly", "popularity": 0.5564738292011019 }, { "name": "Suzanne", "popularity": 0.5281385281385281 }, { "name": "Marlene", "popularity": 0.5128205128205128 }, { "name": "Michelle", "popularity": 0.4911591355599214 }, { "name": "Renee", "popularity": 0.4875 }, { "name": "Shelly", "popularity": 0.47619047619047616 }, { "name": "Sheryl", "popularity": 0.47580645161290325 } ] }, { "gender": "M", "by_name": [ { "name": "Duane", "popularity": 1.064516129032258 }, { "name": "Gerald", "popularity": 0.9387755102040817 }, { "name": "Kim", "popularity": 0.8620689655172413 }, { "name": "Gordon", "popularity": 0.8554216867469879 }, { "name": "Dave", "popularity": 0.835820895522388 }, { "name": "Lyle", "popularity": 0.8253968253968254 }, { "name": "Rick", "popularity": 0.784 }, { "name": "Darrin", "popularity": 0.7307692307692307 }, { "name": "Dale", "popularity": 0.6915584415584416 }, { "name": "Fredrick", "popularity": 0.6730769230769231 }, { "name": "Kurt", "popularity": 0.6162790697674418 }, { "name": "Kirk", "popularity": 0.6056338028169014 }, { "name": "Douglas", "popularity": 0.5559772296015181 }, { "name": "Dennis", "popularity": 0.5336463223787168 }, { "name": "Tim", "popularity": 0.5135135135135135 } ] } ] }, { "state": "MN", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Jodi", "popularity": 2.5454545454545454 }, { "name": "Jody", "popularity": 2.0597014925373136 }, { "name": "Marcella", "popularity": 2 }, { "name": "Kristin", "popularity": 1.8805970149253732 }, { "name": "Roxanne", "popularity": 1.8615384615384616 }, { "name": "Kristine", "popularity": 1.7159090909090908 }, { "name": "Kristi", "popularity": 1.7115384615384615 }, { "name": "Colleen", "popularity": 1.553191489361702 }, { "name": "Harriet", "popularity": 1.5416666666666667 }, { "name": "Julie", "popularity": 1.472 }, { "name": "Lorraine", "popularity": 1.4065040650406504 }, { "name": "Heidi", "popularity": 1.393939393939394 }, { "name": "Shelly", "popularity": 1.3428571428571427 }, { "name": "Delores", "popularity": 1.3243243243243243 }, { "name": "Marlene", "popularity": 1.2564102564102564 } ] }, { "gender": "M", "by_name": [ { "name": "Lyle", "popularity": 3.0793650793650795 }, { "name": "Duane", "popularity": 2.9193548387096775 }, { "name": "Bradley", "popularity": 2.6747967479674797 }, { "name": "Jerome", "popularity": 1.9597315436241611 }, { "name": "Dean", "popularity": 1.955128205128205 }, { "name": "Jason", "popularity": 1.8888888888888888 }, { "name": "Darin", "popularity": 1.6415094339622642 }, { "name": "Gordon", "popularity": 1.6204819277108433 }, { "name": "Todd", "popularity": 1.5364963503649636 }, { "name": "Jon", "popularity": 1.4689655172413794 }, { "name": "Troy", "popularity": 1.4296296296296296 }, { "name": "Dale", "popularity": 1.3993506493506493 }, { "name": "Arnold", "popularity": 1.3660714285714286 }, { "name": "Allan", "popularity": 1.2941176470588236 }, { "name": "Scott", "popularity": 1.2675521821631879 } ] } ] }, { "state": "MO", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Wilma", "popularity": 1.471264367816092 }, { "name": "Opal", "popularity": 1.1546391752577319 }, { "name": "Laverne", "popularity": 1.0727272727272728 }, { "name": "Velma", "popularity": 0.9313725490196079 }, { "name": "Marcella", "popularity": 0.8548387096774194 }, { "name": "Lana", "popularity": 0.8235294117647058 }, { "name": "Christy", "popularity": 0.803921568627451 }, { "name": "Beulah", "popularity": 0.7558139534883721 }, { "name": "Shelly", "popularity": 0.7523809523809524 }, { "name": "Carla", "popularity": 0.7448275862068966 }, { "name": "Glenda", "popularity": 0.7291666666666666 }, { "name": "Georgia", "popularity": 0.725925925925926 }, { "name": "Norma", "popularity": 0.717391304347826 }, { "name": "Erma", "popularity": 0.7121212121212122 }, { "name": "Marsha", "popularity": 0.6438356164383562 } ] }, { "gender": "M", "by_name": [ { "name": "Virgil", "popularity": 1.3974358974358974 }, { "name": "Darin", "popularity": 1.1132075471698113 }, { "name": "Bob", "popularity": 1.0446428571428572 }, { "name": "Jackie", "popularity": 1.0212765957446808 }, { "name": "Everett", "popularity": 0.9230769230769231 }, { "name": "Delbert", "popularity": 0.9090909090909091 }, { "name": "Bill", "popularity": 0.8465608465608465 }, { "name": "Elmer", "popularity": 0.803030303030303 }, { "name": "Garry", "popularity": 0.7 }, { "name": "Vernon", "popularity": 0.6858974358974359 }, { "name": "Lloyd", "popularity": 0.6763005780346821 }, { "name": "Floyd", "popularity": 0.6727272727272727 }, { "name": "Oliver", "popularity": 0.6470588235294118 }, { "name": "Billy", "popularity": 0.6408977556109726 }, { "name": "Marion", "popularity": 0.6 } ] } ] }, { "state": "MS", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Rosie", "popularity": 8.402298850574713 }, { "name": "Annie", "popularity": 5.015576323987539 }, { "name": "Willie", "popularity": 4.903553299492386 }, { "name": "Bobbie", "popularity": 4.2 }, { "name": "Maggie", "popularity": 4.078125 }, { "name": "Mattie", "popularity": 4.051851851851852 }, { "name": "Katie", "popularity": 4.035714285714286 }, { "name": "Lillie", "popularity": 4 }, { "name": "Hattie", "popularity": 3.988235294117647 }, { "name": "Essie", "popularity": 3.9019607843137254 }, { "name": "Johnnie", "popularity": 3.824324324324324 }, { "name": "Lula", "popularity": 3.738095238095238 }, { "name": "Fannie", "popularity": 3.419753086419753 }, { "name": "Minnie", "popularity": 3.1755725190839694 }, { "name": "Jessie", "popularity": 3.0390625 } ] }, { "gender": "M", "by_name": [ { "name": "Willie", "popularity": 6.281837160751566 }, { "name": "Roosevelt", "popularity": 6.078431372549019 }, { "name": "Jessie", "popularity": 5.5353535353535355 }, { "name": "Johnnie", "popularity": 4.339285714285714 }, { "name": "Eddie", "popularity": 3.8680203045685277 }, { "name": "Earnest", "popularity": 3.7941176470588234 }, { "name": "Jimmie", "popularity": 3.744186046511628 }, { "name": "Charlie", "popularity": 3.734265734265734 }, { "name": "Bennie", "popularity": 3.5689655172413794 }, { "name": "Clifton", "popularity": 2.85 }, { "name": "Otis", "popularity": 2.8 }, { "name": "Luther", "popularity": 2.373134328358209 }, { "name": "Sam", "popularity": 2.349056603773585 }, { "name": "Freddie", "popularity": 2.1923076923076925 }, { "name": "Johnny", "popularity": 1.9598540145985401 } ] } ] }, { "state": "MT", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Tami", "popularity": 2.6825396825396823 }, { "name": "Mabel", "popularity": 2.656862745098039 }, { "name": "Pat", "popularity": 2.5925925925925926 }, { "name": "Shelly", "popularity": 2.533333333333333 }, { "name": "Jamie", "popularity": 2.5211267605633805 }, { "name": "Teri", "popularity": 2.417910447761194 }, { "name": "Olive", "popularity": 2.3846153846153846 }, { "name": "Karla", "popularity": 2.3015873015873014 }, { "name": "Kristi", "popularity": 2.1923076923076925 }, { "name": "Patti", "popularity": 2.1194029850746268 }, { "name": "Genevieve", "popularity": 2.065934065934066 }, { "name": "Colleen", "popularity": 1.929078014184397 }, { "name": "Shannon", "popularity": 1.9058823529411764 }, { "name": "Shelley", "popularity": 1.898876404494382 }, { "name": "Marlene", "popularity": 1.7756410256410255 } ] }, { "gender": "M", "by_name": [ { "name": "Kelly", "popularity": 3 }, { "name": "Lyle", "popularity": 2.7142857142857144 }, { "name": "Shawn", "popularity": 2.406779661016949 }, { "name": "Woodrow", "popularity": 2.2884615384615383 }, { "name": "Brett", "popularity": 2.1232876712328768 }, { "name": "Jason", "popularity": 1.9722222222222223 }, { "name": "Brad", "popularity": 1.9615384615384615 }, { "name": "Darin", "popularity": 1.9245283018867925 }, { "name": "Duane", "popularity": 1.8870967741935485 }, { "name": "Darren", "popularity": 1.8144329896907216 }, { "name": "Kirk", "popularity": 1.7605633802816902 }, { "name": "Dan", "popularity": 1.7217391304347827 }, { "name": "Tim", "popularity": 1.6756756756756757 }, { "name": "Lance", "popularity": 1.625 }, { "name": "Rick", "popularity": 1.608 } ] } ] }, { "state": "NC", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Annie", "popularity": 3.015576323987539 }, { "name": "Maggie", "popularity": 2.3125 }, { "name": "Katie", "popularity": 2.142857142857143 }, { "name": "Hattie", "popularity": 2.1294117647058823 }, { "name": "Mamie", "popularity": 1.9726027397260273 }, { "name": "Sadie", "popularity": 1.8928571428571428 }, { "name": "Mable", "popularity": 1.7096774193548387 }, { "name": "Lillie", "popularity": 1.604026845637584 }, { "name": "Shelia", "popularity": 1.5569620253164558 }, { "name": "Rosa", "popularity": 1.5539568345323742 }, { "name": "Fannie", "popularity": 1.4691358024691359 }, { "name": "Hilda", "popularity": 1.4578313253012047 }, { "name": "Rachel", "popularity": 1.425 }, { "name": "Crystal", "popularity": 1.4137931034482758 }, { "name": "Daisy", "popularity": 1.4 } ] }, { "gender": "M", "by_name": [ { "name": "Charlie", "popularity": 2.7132867132867133 }, { "name": "Clifton", "popularity": 2.2 }, { "name": "Bobby", "popularity": 2.021406727828746 }, { "name": "Hubert", "popularity": 1.9692307692307693 }, { "name": "Luther", "popularity": 1.955223880597015 }, { "name": "Johnnie", "popularity": 1.6875 }, { "name": "Donnie", "popularity": 1.6865671641791045 }, { "name": "Horace", "popularity": 1.6451612903225807 }, { "name": "Clyde", "popularity": 1.423841059602649 }, { "name": "Claude", "popularity": 1.4175824175824177 }, { "name": "Willie", "popularity": 1.3736951983298538 }, { "name": "Johnny", "popularity": 1.3722627737226278 }, { "name": "Ricky", "popularity": 1.2862068965517242 }, { "name": "Jimmy", "popularity": 1.2581818181818183 }, { "name": "Marshall", "popularity": 1.1967213114754098 } ] } ] }, { "state": "ND", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Kristi", "popularity": 6.365384615384615 }, { "name": "Karla", "popularity": 5.412698412698413 }, { "name": "Violet", "popularity": 4.056603773584905 }, { "name": "Myrtle", "popularity": 3.6031746031746033 }, { "name": "Shelly", "popularity": 3.5142857142857142 }, { "name": "Viola", "popularity": 3.296875 }, { "name": "Roxanne", "popularity": 3.276923076923077 }, { "name": "Jodi", "popularity": 3.1363636363636362 }, { "name": "Marlene", "popularity": 3.1346153846153846 }, { "name": "Paulette", "popularity": 3.0434782608695654 }, { "name": "Olga", "popularity": 2.8529411764705883 }, { "name": "Hilda", "popularity": 2.8313253012048194 }, { "name": "Olive", "popularity": 2.6923076923076925 }, { "name": "Leona", "popularity": 2.641509433962264 }, { "name": "Delores", "popularity": 2.614864864864865 } ] }, { "gender": "M", "by_name": [ { "name": "Lyle", "popularity": 6.333333333333333 }, { "name": "Darin", "popularity": 6.132075471698113 }, { "name": "Troy", "popularity": 5.985185185185185 }, { "name": "Duane", "popularity": 5.838709677419355 }, { "name": "Kelly", "popularity": 3.611111111111111 }, { "name": "Brent", "popularity": 3.3048780487804876 }, { "name": "Darren", "popularity": 3.2061855670103094 }, { "name": "Bradley", "popularity": 2.991869918699187 }, { "name": "Lynn", "popularity": 2.966666666666667 }, { "name": "Jason", "popularity": 2.8194444444444446 }, { "name": "Arnold", "popularity": 2.5535714285714284 }, { "name": "Gordon", "popularity": 2.5301204819277108 }, { "name": "Vernon", "popularity": 2.5256410256410255 }, { "name": "Kim", "popularity": 2.4655172413793105 }, { "name": "Dean", "popularity": 2.4358974358974357 } ] } ] }, { "state": "NE", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Kristi", "popularity": 3.1923076923076925 }, { "name": "Opal", "popularity": 2.7422680412371134 }, { "name": "Erma", "popularity": 2.196969696969697 }, { "name": "Maxine", "popularity": 2.022727272727273 }, { "name": "Shelly", "popularity": 1.9619047619047618 }, { "name": "Jody", "popularity": 1.5223880597014925 }, { "name": "Tami", "popularity": 1.492063492063492 }, { "name": "Jodi", "popularity": 1.4090909090909092 }, { "name": "Julie", "popularity": 1.408 }, { "name": "Olive", "popularity": 1.4038461538461537 }, { "name": "Leona", "popularity": 1.3773584905660377 }, { "name": "Wilma", "popularity": 1.3563218390804597 }, { "name": "Kay", "popularity": 1.3057851239669422 }, { "name": "Deanna", "popularity": 1.2429906542056075 }, { "name": "Christy", "popularity": 1.2352941176470589 } ] }, { "gender": "M", "by_name": [ { "name": "Lyle", "popularity": 4.507936507936508 }, { "name": "Duane", "popularity": 2.4596774193548385 }, { "name": "Darin", "popularity": 2.3773584905660377 }, { "name": "Kent", "popularity": 2.140845070422535 }, { "name": "Dean", "popularity": 1.814102564102564 }, { "name": "Bradley", "popularity": 1.8130081300813008 }, { "name": "Dale", "popularity": 1.8051948051948052 }, { "name": "Delbert", "popularity": 1.709090909090909 }, { "name": "Rex", "popularity": 1.6491228070175439 }, { "name": "Virgil", "popularity": 1.6282051282051282 }, { "name": "Troy", "popularity": 1.6074074074074074 }, { "name": "Lynn", "popularity": 1.55 }, { "name": "Kirk", "popularity": 1.4929577464788732 }, { "name": "Rick", "popularity": 1.408 }, { "name": "Kelly", "popularity": 1.4027777777777777 } ] } ] }, { "state": "NH", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Kristen", "popularity": 6.69811320754717 }, { "name": "Claire", "popularity": 6.2025316455696204 }, { "name": "Jeannette", "popularity": 4.911764705882353 }, { "name": "Priscilla", "popularity": 4.8625 }, { "name": "Heidi", "popularity": 3.888888888888889 }, { "name": "Blanche", "popularity": 3.8076923076923075 }, { "name": "Muriel", "popularity": 3.611940298507463 }, { "name": "Olive", "popularity": 3.3846153846153846 }, { "name": "Pauline", "popularity": 3.3132530120481927 }, { "name": "Nicole", "popularity": 2.7454545454545456 }, { "name": "Kristin", "popularity": 2.5970149253731343 }, { "name": "Sophie", "popularity": 2.5081967213114753 }, { "name": "Stella", "popularity": 2.4915254237288136 }, { "name": "Lorraine", "popularity": 2.1747967479674797 }, { "name": "Gertrude", "popularity": 2.1547619047619047 } ] }, { "gender": "M", "by_name": [ { "name": "Roland", "popularity": 7.726315789473684 }, { "name": "Maurice", "popularity": 6.010204081632653 }, { "name": "Gerard", "popularity": 5.138888888888889 }, { "name": "Dana", "popularity": 4.425925925925926 }, { "name": "Marc", "popularity": 3.1809523809523808 }, { "name": "Leo", "popularity": 2.687116564417178 }, { "name": "Normand", "popularity": 2.308641975308642 }, { "name": "Shawn", "popularity": 2.152542372881356 }, { "name": "Jonathan", "popularity": 2.135593220338983 }, { "name": "Peter", "popularity": 1.9781181619256019 }, { "name": "Norman", "popularity": 1.9540636042402826 }, { "name": "Roger", "popularity": 1.827659574468085 }, { "name": "Jason", "popularity": 1.6111111111111112 }, { "name": "Bruce", "popularity": 1.4939759036144578 }, { "name": "Scott", "popularity": 1.3453510436432639 } ] } ] }, { "state": "NJ", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Maryann", "popularity": 2.289473684210526 }, { "name": "Claire", "popularity": 1.8734177215189873 }, { "name": "Eileen", "popularity": 1.5776699029126213 }, { "name": "Antoinette", "popularity": 1.5256410256410255 }, { "name": "Angelina", "popularity": 1.4615384615384615 }, { "name": "Rosemarie", "popularity": 1.4179104477611941 }, { "name": "Madeline", "popularity": 1.28 }, { "name": "Maureen", "popularity": 1.2674418604651163 }, { "name": "Marianne", "popularity": 1.2142857142857142 }, { "name": "Michele", "popularity": 1.1476014760147601 }, { "name": "Doreen", "popularity": 1.1384615384615384 }, { "name": "Joan", "popularity": 1.0298507462686568 }, { "name": "Eleanor", "popularity": 0.9929078014184397 }, { "name": "Marion", "popularity": 0.9710144927536232 }, { "name": "Sophie", "popularity": 0.9672131147540983 } ] }, { "gender": "M", "by_name": [ { "name": "Nicholas", "popularity": 2.1463414634146343 }, { "name": "Dominick", "popularity": 1.9607843137254901 }, { "name": "Angelo", "popularity": 1.9107142857142858 }, { "name": "Vincent", "popularity": 1.6712328767123288 }, { "name": "Peter", "popularity": 1.4923413566739605 }, { "name": "Alexander", "popularity": 1.2941176470588236 }, { "name": "Salvatore", "popularity": 1.288888888888889 }, { "name": "Anthony", "popularity": 1.2300884955752212 }, { "name": "Gerard", "popularity": 1.1666666666666667 }, { "name": "Joseph", "popularity": 1.1472868217054264 }, { "name": "Frank", "popularity": 0.9502824858757062 }, { "name": "Louis", "popularity": 0.9310344827586207 }, { "name": "Frederick", "popularity": 0.8032128514056225 }, { "name": "Edward", "popularity": 0.7849117174959872 }, { "name": "Theodore", "popularity": 0.7846153846153846 } ] } ] }, { "state": "NM", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Cecilia", "popularity": 6 }, { "name": "Ramona", "popularity": 4.694444444444445 }, { "name": "Carmen", "popularity": 4.421052631578948 }, { "name": "Bernadette", "popularity": 3.9649122807017543 }, { "name": "Maria", "popularity": 3.7816455696202533 }, { "name": "Lucy", "popularity": 3.595419847328244 }, { "name": "Priscilla", "popularity": 3.5625 }, { "name": "Flora", "popularity": 2.96875 }, { "name": "Yolanda", "popularity": 2.7714285714285714 }, { "name": "Dora", "popularity": 2.67032967032967 }, { "name": "Marcella", "popularity": 2.6451612903225805 }, { "name": "Lydia", "popularity": 2.4210526315789473 }, { "name": "Lupe", "popularity": 2.2222222222222223 }, { "name": "Stella", "popularity": 2.1610169491525424 }, { "name": "Rosie", "popularity": 2.1149425287356323 } ] }, { "gender": "M", "by_name": [ { "name": "Manuel", "popularity": 10.218181818181819 }, { "name": "Jose", "popularity": 7.42512077294686 }, { "name": "Antonio", "popularity": 5.476190476190476 }, { "name": "Gilbert", "popularity": 5.227642276422764 }, { "name": "Ruben", "popularity": 5.016393442622951 }, { "name": "Juan", "popularity": 4.84251968503937 }, { "name": "Carlos", "popularity": 4.2784810126582276 }, { "name": "Joe", "popularity": 3.8354978354978355 }, { "name": "Pedro", "popularity": 2.8870967741935485 }, { "name": "Alex", "popularity": 2.765625 }, { "name": "Luis", "popularity": 2.764705882352941 }, { "name": "Francisco", "popularity": 2.75 }, { "name": "Miguel", "popularity": 2.740740740740741 }, { "name": "Jesus", "popularity": 2.676470588235294 }, { "name": "Bennie", "popularity": 2.5172413793103448 } ] } ] }, { "state": "NV", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Olga", "popularity": 5.102941176470588 }, { "name": "Traci", "popularity": 4.338709677419355 }, { "name": "Shannon", "popularity": 4.2 }, { "name": "Stacey", "popularity": 4.148148148148148 }, { "name": "Pat", "popularity": 3.9814814814814814 }, { "name": "Toni", "popularity": 3.1648351648351647 }, { "name": "Natalie", "popularity": 3.15 }, { "name": "Teri", "popularity": 3.014925373134328 }, { "name": "Kelli", "popularity": 2.981818181818182 }, { "name": "Marguerite", "popularity": 2.9473684210526314 }, { "name": "Tina", "popularity": 2.8875 }, { "name": "Blanche", "popularity": 2.7948717948717947 }, { "name": "Tami", "popularity": 2.746031746031746 }, { "name": "Nicole", "popularity": 2.7454545454545456 }, { "name": "Leslie", "popularity": 2.672727272727273 } ] }, { "gender": "M", "by_name": [ { "name": "Jason", "popularity": 4.333333333333333 }, { "name": "Shawn", "popularity": 4.177966101694915 }, { "name": "Troy", "popularity": 4.022222222222222 }, { "name": "Kelly", "popularity": 3.736111111111111 }, { "name": "Woodrow", "popularity": 3.6538461538461537 }, { "name": "Lance", "popularity": 2.982142857142857 }, { "name": "Darren", "popularity": 2.711340206185567 }, { "name": "Mike", "popularity": 2.526086956521739 }, { "name": "Brent", "popularity": 2 }, { "name": "Aaron", "popularity": 1.9864864864864864 }, { "name": "Adam", "popularity": 1.962962962962963 }, { "name": "Darin", "popularity": 1.9622641509433962 }, { "name": "Brett", "popularity": 1.9589041095890412 }, { "name": "Delbert", "popularity": 1.8909090909090909 }, { "name": "Tracy", "popularity": 1.639344262295082 } ] } ] }, { "state": "NY", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Antoinette", "popularity": 1.7564102564102564 }, { "name": "Eileen", "popularity": 1.674757281553398 }, { "name": "Madeline", "popularity": 1.6533333333333333 }, { "name": "Miriam", "popularity": 1.618421052631579 }, { "name": "Muriel", "popularity": 1.5671641791044777 }, { "name": "Angelina", "popularity": 1.5 }, { "name": "Rosemarie", "popularity": 1.462686567164179 }, { "name": "Maureen", "popularity": 1.3546511627906976 }, { "name": "Maryann", "popularity": 1.1578947368421053 }, { "name": "Josephine", "popularity": 1 }, { "name": "Marion", "popularity": 1 }, { "name": "Claire", "popularity": 0.9873417721518988 }, { "name": "Anne", "popularity": 0.9867109634551495 }, { "name": "Joan", "popularity": 0.9154228855721394 }, { "name": "Doreen", "popularity": 0.9076923076923077 } ] }, { "gender": "M", "by_name": [ { "name": "Salvatore", "popularity": 2.2222222222222223 }, { "name": "Angelo", "popularity": 2.0535714285714284 }, { "name": "Dominick", "popularity": 2.019607843137255 }, { "name": "Vincent", "popularity": 1.9634703196347032 }, { "name": "Nicholas", "popularity": 1.7967479674796747 }, { "name": "Gerard", "popularity": 1.7916666666666667 }, { "name": "Peter", "popularity": 1.687089715536105 }, { "name": "Stuart", "popularity": 1.2096774193548387 }, { "name": "Anthony", "popularity": 1.1843657817109146 }, { "name": "Seymour", "popularity": 1.1111111111111112 }, { "name": "Alexander", "popularity": 1.035294117647059 }, { "name": "Martin", "popularity": 0.9146341463414634 }, { "name": "Neil", "popularity": 0.9078947368421053 }, { "name": "Philip", "popularity": 0.8896551724137931 }, { "name": "Louis", "popularity": 0.8488063660477454 } ] } ] }, { "state": "OH", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Beth", "popularity": 0.6778523489932886 }, { "name": "Patty", "popularity": 0.6506024096385542 }, { "name": "Sue", "popularity": 0.6379310344827587 }, { "name": "Amy", "popularity": 0.5906976744186047 }, { "name": "Marcella", "popularity": 0.5 }, { "name": "Dianna", "popularity": 0.45588235294117646 }, { "name": "Becky", "popularity": 0.44954128440366975 }, { "name": "Tonya", "popularity": 0.43333333333333335 }, { "name": "Kimberly", "popularity": 0.42205882352941176 }, { "name": "Rosemary", "popularity": 0.4117647058823529 }, { "name": "Marcia", "popularity": 0.3974358974358974 }, { "name": "Darla", "popularity": 0.39655172413793105 }, { "name": "Penny", "popularity": 0.3937007874015748 }, { "name": "Sandy", "popularity": 0.3924050632911392 }, { "name": "Marilyn", "popularity": 0.3897550111358575 } ] }, { "gender": "M", "by_name": [ { "name": "Rick", "popularity": 0.776 }, { "name": "Tim", "popularity": 0.7027027027027027 }, { "name": "Dave", "popularity": 0.6865671641791045 }, { "name": "Dale", "popularity": 0.5974025974025974 }, { "name": "Wilbur", "popularity": 0.5873015873015873 }, { "name": "Darrin", "popularity": 0.5192307692307693 }, { "name": "Jeffrey", "popularity": 0.4994152046783626 }, { "name": "Tom", "popularity": 0.4934210526315789 }, { "name": "Timothy", "popularity": 0.4813753581661891 }, { "name": "Jeffery", "popularity": 0.47520661157024796 }, { "name": "Jeff", "popularity": 0.423841059602649 }, { "name": "Ted", "popularity": 0.41025641025641024 }, { "name": "Karl", "popularity": 0.36904761904761907 }, { "name": "Carl", "popularity": 0.3557312252964427 }, { "name": "Dwight", "popularity": 0.35135135135135137 } ] } ] }, { "state": "OK", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Opal", "popularity": 4.134020618556701 }, { "name": "Billie", "popularity": 3.706422018348624 }, { "name": "Shelly", "popularity": 2.4285714285714284 }, { "name": "Velma", "popularity": 2.196078431372549 }, { "name": "Kristi", "popularity": 2.1923076923076925 }, { "name": "Patsy", "popularity": 2.1538461538461537 }, { "name": "Darla", "popularity": 2.1379310344827585 }, { "name": "Wanda", "popularity": 2.1143695014662756 }, { "name": "Wilma", "popularity": 1.9310344827586208 }, { "name": "Geneva", "popularity": 1.7857142857142858 }, { "name": "Lola", "popularity": 1.7647058823529411 }, { "name": "Juanita", "popularity": 1.7043478260869565 }, { "name": "Erma", "popularity": 1.6818181818181819 }, { "name": "Kelli", "popularity": 1.6545454545454545 }, { "name": "Ruby", "popularity": 1.608695652173913 } ] }, { "gender": "M", "by_name": [ { "name": "Billy", "popularity": 3.13715710723192 }, { "name": "Jackie", "popularity": 2.7127659574468086 }, { "name": "Jimmie", "popularity": 2.5426356589147288 }, { "name": "Jimmy", "popularity": 2.367272727272727 }, { "name": "Tommy", "popularity": 2.2923976608187133 }, { "name": "Bill", "popularity": 2.2433862433862433 }, { "name": "Cecil", "popularity": 2.1478260869565218 }, { "name": "Bobby", "popularity": 2.110091743119266 }, { "name": "Delbert", "popularity": 2.036363636363636 }, { "name": "Bob", "popularity": 1.9642857142857142 }, { "name": "Virgil", "popularity": 1.8333333333333333 }, { "name": "Floyd", "popularity": 1.7515151515151515 }, { "name": "Rickey", "popularity": 1.6704545454545454 }, { "name": "Don", "popularity": 1.5401069518716577 }, { "name": "Ronnie", "popularity": 1.471698113207547 } ] } ] }, { "state": "OR", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Tami", "popularity": 3.0952380952380953 }, { "name": "Shannon", "popularity": 2.6470588235294117 }, { "name": "Shelley", "popularity": 1.9438202247191012 }, { "name": "Julie", "popularity": 1.9093333333333333 }, { "name": "Kristi", "popularity": 1.9038461538461537 }, { "name": "Tamara", "popularity": 1.882882882882883 }, { "name": "Shelly", "popularity": 1.7047619047619047 }, { "name": "Lucile", "popularity": 1.694915254237288 }, { "name": "Jan", "popularity": 1.5569620253164558 }, { "name": "Becky", "popularity": 1.4770642201834863 }, { "name": "Deanna", "popularity": 1.4485981308411215 }, { "name": "Kelli", "popularity": 1.4363636363636363 }, { "name": "Teri", "popularity": 1.4328358208955223 }, { "name": "Karla", "popularity": 1.4126984126984128 }, { "name": "Traci", "popularity": 1.3709677419354838 } ] }, { "gender": "M", "by_name": [ { "name": "Darin", "popularity": 2.981132075471698 }, { "name": "Woodrow", "popularity": 2.75 }, { "name": "Kelly", "popularity": 2.5694444444444446 }, { "name": "Rick", "popularity": 2.16 }, { "name": "Jason", "popularity": 2.0277777777777777 }, { "name": "Jim", "popularity": 1.8488372093023255 }, { "name": "Bob", "popularity": 1.7857142857142858 }, { "name": "Dan", "popularity": 1.7217391304347827 }, { "name": "Dave", "popularity": 1.6567164179104477 }, { "name": "Brad", "popularity": 1.6025641025641026 }, { "name": "Delbert", "popularity": 1.6 }, { "name": "Jeff", "popularity": 1.5827814569536425 }, { "name": "Mike", "popularity": 1.5608695652173914 }, { "name": "Lyle", "popularity": 1.5238095238095237 }, { "name": "Bradley", "popularity": 1.5121951219512195 } ] } ] }, { "state": "PA", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Anna", "popularity": 1.387900355871886 }, { "name": "Dolores", "popularity": 1.1302681992337165 }, { "name": "Maryann", "popularity": 1.0526315789473684 }, { "name": "Eleanor", "popularity": 0.9787234042553191 }, { "name": "Miriam", "popularity": 0.9736842105263158 }, { "name": "Bernadette", "popularity": 0.9649122807017544 }, { "name": "Marian", "popularity": 0.7484276729559748 }, { "name": "Sophie", "popularity": 0.7377049180327869 }, { "name": "Rosemarie", "popularity": 0.7164179104477612 }, { "name": "Agnes", "popularity": 0.7114093959731543 }, { "name": "Helen", "popularity": 0.6921692169216922 }, { "name": "Florence", "popularity": 0.6865203761755486 }, { "name": "Stella", "popularity": 0.6271186440677966 }, { "name": "Joanne", "popularity": 0.6220472440944882 }, { "name": "Marianne", "popularity": 0.6 } ] }, { "gender": "M", "by_name": [ { "name": "Francis", "popularity": 1.394648829431438 }, { "name": "Harry", "popularity": 1.1466346153846154 }, { "name": "Joseph", "popularity": 1.012735326688815 }, { "name": "Nicholas", "popularity": 0.9186991869918699 }, { "name": "Barry", "popularity": 0.7129629629629629 }, { "name": "Bernard", "popularity": 0.6682242990654206 }, { "name": "Vincent", "popularity": 0.5981735159817352 }, { "name": "Edward", "popularity": 0.5947030497592295 }, { "name": "Andrew", "popularity": 0.5558659217877095 }, { "name": "Samuel", "popularity": 0.5517241379310345 }, { "name": "Theodore", "popularity": 0.5282051282051282 }, { "name": "Alexander", "popularity": 0.4823529411764706 }, { "name": "Albert", "popularity": 0.46331236897274636 }, { "name": "Stanley", "popularity": 0.4523076923076923 }, { "name": "Frank", "popularity": 0.4406779661016949 } ] } ] }, { "state": "RI", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Claire", "popularity": 7.050632911392405 }, { "name": "Kristen", "popularity": 4.245283018867925 }, { "name": "Muriel", "popularity": 4.164179104477612 }, { "name": "Angelina", "popularity": 4 }, { "name": "Doreen", "popularity": 3.4 }, { "name": "Maureen", "popularity": 3.2209302325581395 }, { "name": "Jeannette", "popularity": 3.014705882352941 }, { "name": "Madeline", "popularity": 2.48 }, { "name": "Flora", "popularity": 2.3125 }, { "name": "Jennie", "popularity": 2.288659793814433 }, { "name": "Gertrude", "popularity": 2.2083333333333335 }, { "name": "Laurie", "popularity": 2.103139013452915 }, { "name": "Gail", "popularity": 2.0113636363636362 }, { "name": "Olga", "popularity": 1.9558823529411764 }, { "name": "Sophie", "popularity": 1.9508196721311475 } ] }, { "gender": "M", "by_name": [ { "name": "Roland", "popularity": 4.2631578947368425 }, { "name": "Gerard", "popularity": 3.1666666666666665 }, { "name": "Normand", "popularity": 2.9012345679012346 }, { "name": "Angelo", "popularity": 2.357142857142857 }, { "name": "Leo", "popularity": 2.3067484662576687 }, { "name": "Marc", "popularity": 2.276190476190476 }, { "name": "Alfred", "popularity": 1.9681274900398407 }, { "name": "Peter", "popularity": 1.8884026258205688 }, { "name": "Manuel", "popularity": 1.8181818181818181 }, { "name": "Raymond", "popularity": 1.7651715039577835 }, { "name": "Francis", "popularity": 1.6421404682274248 }, { "name": "Maurice", "popularity": 1.5510204081632653 }, { "name": "Vincent", "popularity": 1.5205479452054795 }, { "name": "Antonio", "popularity": 1.4761904761904763 }, { "name": "Anthony", "popularity": 1.3200589970501475 } ] } ] }, { "state": "SC", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Hattie", "popularity": 4.223529411764706 }, { "name": "Rosa", "popularity": 4.093525179856115 }, { "name": "Maggie", "popularity": 3.984375 }, { "name": "Janie", "popularity": 3.948717948717949 }, { "name": "Annie", "popularity": 3.8161993769470404 }, { "name": "Mamie", "popularity": 3.7534246575342465 }, { "name": "Daisy", "popularity": 3.5428571428571427 }, { "name": "Lillie", "popularity": 3.5167785234899327 }, { "name": "Sadie", "popularity": 3.125 }, { "name": "Carrie", "popularity": 3.1142857142857143 }, { "name": "Essie", "popularity": 2.803921568627451 }, { "name": "Lula", "popularity": 2.6904761904761907 }, { "name": "Mattie", "popularity": 2.6296296296296298 }, { "name": "Willie", "popularity": 2.4060913705583755 }, { "name": "Jessie", "popularity": 2.265625 } ] }, { "gender": "M", "by_name": [ { "name": "Marion", "popularity": 4.875 }, { "name": "Nathaniel", "popularity": 4.375 }, { "name": "Willie", "popularity": 3.9478079331941545 }, { "name": "Roosevelt", "popularity": 3.3333333333333335 }, { "name": "Woodrow", "popularity": 2.826923076923077 }, { "name": "Luther", "popularity": 2.716417910447761 }, { "name": "Johnnie", "popularity": 2.5892857142857144 }, { "name": "Julius", "popularity": 2.5714285714285716 }, { "name": "Leroy", "popularity": 2.511627906976744 }, { "name": "Charlie", "popularity": 2.4055944055944054 }, { "name": "Bennie", "popularity": 2.3448275862068964 }, { "name": "Freddie", "popularity": 2.1538461538461537 }, { "name": "Otis", "popularity": 2.1333333333333333 }, { "name": "Horace", "popularity": 2.096774193548387 }, { "name": "Ben", "popularity": 1.7611940298507462 } ] } ] }, { "state": "SD", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Kristi", "popularity": 4.384615384615385 }, { "name": "Karla", "popularity": 3.9365079365079363 }, { "name": "Darla", "popularity": 3.3620689655172415 }, { "name": "Tamara", "popularity": 2.774774774774775 }, { "name": "Jody", "popularity": 2.611940298507463 }, { "name": "Violet", "popularity": 2.5660377358490565 }, { "name": "Mabel", "popularity": 2.5588235294117645 }, { "name": "Kay", "popularity": 2.520661157024793 }, { "name": "Delores", "popularity": 2.439189189189189 }, { "name": "Maxine", "popularity": 2.3484848484848486 }, { "name": "Verna", "popularity": 2.2837837837837838 }, { "name": "Viola", "popularity": 2.28125 }, { "name": "Olive", "popularity": 2.173076923076923 }, { "name": "Leona", "popularity": 2.169811320754717 }, { "name": "Lana", "popularity": 2.0784313725490198 } ] }, { "gender": "M", "by_name": [ { "name": "Lyle", "popularity": 7.285714285714286 }, { "name": "Darin", "popularity": 4.962264150943396 }, { "name": "Kelly", "popularity": 4.236111111111111 }, { "name": "Duane", "popularity": 4.088709677419355 }, { "name": "Bradley", "popularity": 3.2113821138211383 }, { "name": "Brad", "popularity": 2.628205128205128 }, { "name": "Troy", "popularity": 2.5555555555555554 }, { "name": "Todd", "popularity": 2.4306569343065694 }, { "name": "Delbert", "popularity": 2.3636363636363638 }, { "name": "Dean", "popularity": 2.301282051282051 }, { "name": "Dale", "popularity": 2.2305194805194803 }, { "name": "Elmer", "popularity": 1.9090909090909092 }, { "name": "Daryl", "popularity": 1.896551724137931 }, { "name": "Kim", "popularity": 1.8620689655172413 }, { "name": "Virgil", "popularity": 1.858974358974359 } ] } ] }, { "state": "TN", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Shelia", "popularity": 2.7721518987341773 }, { "name": "Bobbie", "popularity": 1.82 }, { "name": "Wilma", "popularity": 1.5689655172413792 }, { "name": "Ruby", "popularity": 1.562111801242236 }, { "name": "Patsy", "popularity": 1.5384615384615385 }, { "name": "Billie", "popularity": 1.4770642201834863 }, { "name": "Mattie", "popularity": 1.451851851851852 }, { "name": "Glenda", "popularity": 1.4027777777777777 }, { "name": "Geneva", "popularity": 1.3979591836734695 }, { "name": "Willie", "popularity": 1.3908629441624365 }, { "name": "Maggie", "popularity": 1.375 }, { "name": "Melissa", "popularity": 1.251082251082251 }, { "name": "Wanda", "popularity": 1.2287390029325513 }, { "name": "Tonya", "popularity": 1.211111111111111 }, { "name": "Johnnie", "popularity": 1.2027027027027026 } ] }, { "gender": "M", "by_name": [ { "name": "Billy", "popularity": 2.3840399002493764 }, { "name": "Jackie", "popularity": 2.265957446808511 }, { "name": "Bobby", "popularity": 2.217125382262997 }, { "name": "Rickey", "popularity": 2.0113636363636362 }, { "name": "Donnie", "popularity": 1.9701492537313432 }, { "name": "Jimmy", "popularity": 1.8945454545454545 }, { "name": "Ronnie", "popularity": 1.721698113207547 }, { "name": "Hubert", "popularity": 1.6 }, { "name": "Luther", "popularity": 1.5970149253731343 }, { "name": "Claude", "popularity": 1.5384615384615385 }, { "name": "Tommy", "popularity": 1.5029239766081872 }, { "name": "Johnny", "popularity": 1.4817518248175183 }, { "name": "Ricky", "popularity": 1.4793103448275862 }, { "name": "Hugh", "popularity": 1.4050632911392404 }, { "name": "Charlie", "popularity": 1.2797202797202798 } ] } ] }, { "state": "TX", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Maria", "popularity": 5.031645569620253 }, { "name": "Guadalupe", "popularity": 2.7444444444444445 }, { "name": "Yolanda", "popularity": 2.6952380952380954 }, { "name": "Billie", "popularity": 2.4954128440366974 }, { "name": "Irma", "popularity": 2.364864864864865 }, { "name": "Rosa", "popularity": 2.338129496402878 }, { "name": "Alicia", "popularity": 2.303030303030303 }, { "name": "Janie", "popularity": 2.1794871794871793 }, { "name": "Dora", "popularity": 1.835164835164835 }, { "name": "Olga", "popularity": 1.7794117647058822 }, { "name": "Bobbie", "popularity": 1.6 }, { "name": "Patsy", "popularity": 1.5961538461538463 }, { "name": "Carmen", "popularity": 1.5894736842105264 }, { "name": "Lydia", "popularity": 1.5789473684210527 }, { "name": "Juanita", "popularity": 1.5521739130434782 } ] }, { "gender": "M", "by_name": [ { "name": "Juan", "popularity": 5.606299212598425 }, { "name": "Jose", "popularity": 4.903381642512077 }, { "name": "Ruben", "popularity": 4.508196721311475 }, { "name": "Manuel", "popularity": 4.036363636363636 }, { "name": "Jesus", "popularity": 3.764705882352941 }, { "name": "Pedro", "popularity": 3.6774193548387095 }, { "name": "Roberto", "popularity": 3.6176470588235294 }, { "name": "Ricardo", "popularity": 3.5272727272727273 }, { "name": "Raul", "popularity": 3.4927536231884058 }, { "name": "Carlos", "popularity": 3.3164556962025316 }, { "name": "Francisco", "popularity": 3.3088235294117645 }, { "name": "Antonio", "popularity": 3.2738095238095237 }, { "name": "Hector", "popularity": 2.5283018867924527 }, { "name": "Guadalupe", "popularity": 2.476923076923077 }, { "name": "Joe", "popularity": 2.1277056277056277 } ] } ] }, { "state": "UT", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Robyn", "popularity": 5.60377358490566 }, { "name": "Sherrie", "popularity": 4.568627450980392 }, { "name": "Kristine", "popularity": 3.340909090909091 }, { "name": "Erma", "popularity": 3.1818181818181817 }, { "name": "Natalie", "popularity": 3.1666666666666665 }, { "name": "Becky", "popularity": 3.0275229357798166 }, { "name": "Colleen", "popularity": 3.0141843971631204 }, { "name": "Jan", "popularity": 2.949367088607595 }, { "name": "Julie", "popularity": 2.7466666666666666 }, { "name": "Jody", "popularity": 2.373134328358209 }, { "name": "Heidi", "popularity": 2.303030303030303 }, { "name": "Lucile", "popularity": 2.2203389830508473 }, { "name": "Leslie", "popularity": 2.175757575757576 }, { "name": "Shelly", "popularity": 2.123809523809524 }, { "name": "Teri", "popularity": 2.1044776119402986 } ] }, { "gender": "M", "by_name": [ { "name": "Brent", "popularity": 10.182926829268293 }, { "name": "Lynn", "popularity": 9 }, { "name": "Kelly", "popularity": 7.111111111111111 }, { "name": "Kent", "popularity": 7.070422535211268 }, { "name": "Kim", "popularity": 5.931034482758621 }, { "name": "Darin", "popularity": 5.528301886792453 }, { "name": "Woodrow", "popularity": 5.365384615384615 }, { "name": "Brad", "popularity": 4.5 }, { "name": "Max", "popularity": 4.136986301369863 }, { "name": "Troy", "popularity": 4.029629629629629 }, { "name": "Rex", "popularity": 3.9298245614035086 }, { "name": "Tracy", "popularity": 3.2459016393442623 }, { "name": "Kerry", "popularity": 3.0344827586206895 }, { "name": "Don", "popularity": 2.978609625668449 }, { "name": "Jay", "popularity": 2.9545454545454546 } ] } ] }, { "state": "VA", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Nannie", "popularity": 1.721311475409836 }, { "name": "Vanessa", "popularity": 1.510204081632653 }, { "name": "Rosa", "popularity": 1.330935251798561 }, { "name": "Shelia", "popularity": 1.3291139240506329 }, { "name": "Lucy", "popularity": 1.2290076335877862 }, { "name": "Fannie", "popularity": 1.0617283950617284 }, { "name": "Elsie", "popularity": 1.0545454545454545 }, { "name": "Susie", "popularity": 1.051948051948052 }, { "name": "Thelma", "popularity": 0.9695817490494296 }, { "name": "Hattie", "popularity": 0.9647058823529412 }, { "name": "Iris", "popularity": 0.9642857142857143 }, { "name": "Nellie", "popularity": 0.9618320610687023 }, { "name": "Angela", "popularity": 0.9276729559748428 }, { "name": "Virginia", "popularity": 0.9216216216216216 }, { "name": "Estelle", "popularity": 0.9090909090909091 } ] }, { "gender": "M", "by_name": [ { "name": "Charlie", "popularity": 1.7622377622377623 }, { "name": "Clifton", "popularity": 1.7 }, { "name": "Claude", "popularity": 1.6263736263736264 }, { "name": "Lewis", "popularity": 1.4722222222222223 }, { "name": "Luther", "popularity": 1.4029850746268657 }, { "name": "Calvin", "popularity": 1.2380952380952381 }, { "name": "Earnest", "popularity": 1.1911764705882353 }, { "name": "Otis", "popularity": 1.1833333333333333 }, { "name": "Marshall", "popularity": 1.1147540983606556 }, { "name": "Cecil", "popularity": 1.1130434782608696 }, { "name": "Nelson", "popularity": 1.0892857142857142 }, { "name": "Reginald", "popularity": 1.0506329113924051 }, { "name": "Franklin", "popularity": 1.0327868852459017 }, { "name": "Woodrow", "popularity": 1.0192307692307692 }, { "name": "Clarence", "popularity": 0.9739413680781759 } ] } ] }, { "state": "VT", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Madeline", "popularity": 4.8 }, { "name": "Marion", "popularity": 4.1352657004830915 }, { "name": "Laurie", "popularity": 4.013452914798206 }, { "name": "Blanche", "popularity": 3.9358974358974357 }, { "name": "Claire", "popularity": 3.481012658227848 }, { "name": "Olive", "popularity": 3 }, { "name": "Priscilla", "popularity": 2.9125 }, { "name": "Heather", "popularity": 2.835294117647059 }, { "name": "Heidi", "popularity": 2.7373737373737375 }, { "name": "Penny", "popularity": 2.2755905511811023 }, { "name": "Marguerite", "popularity": 2.2736842105263158 }, { "name": "Pauline", "popularity": 2.2730923694779115 }, { "name": "Muriel", "popularity": 2.2686567164179103 }, { "name": "Tina", "popularity": 2.25 }, { "name": "Jeannette", "popularity": 2.161764705882353 } ] }, { "gender": "M", "by_name": [ { "name": "Jason", "popularity": 4.138888888888889 }, { "name": "Reginald", "popularity": 3.6962025316455698 }, { "name": "Maurice", "popularity": 3.693877551020408 }, { "name": "Roland", "popularity": 3.3684210526315788 }, { "name": "Dana", "popularity": 3.314814814814815 }, { "name": "Wendell", "popularity": 2.7169811320754715 }, { "name": "Francis", "popularity": 2.6354515050167224 }, { "name": "Bernard", "popularity": 2.4953271028037385 }, { "name": "Gordon", "popularity": 2.4578313253012047 }, { "name": "Everett", "popularity": 2.2435897435897436 }, { "name": "Sean", "popularity": 2.1512605042016806 }, { "name": "Shawn", "popularity": 2.1440677966101696 }, { "name": "Clayton", "popularity": 2 }, { "name": "Kim", "popularity": 1.793103448275862 }, { "name": "Todd", "popularity": 1.7627737226277371 } ] } ] }, { "state": "WA", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Tami", "popularity": 2.9682539682539684 }, { "name": "Shannon", "popularity": 2.2 }, { "name": "Kristi", "popularity": 1.7884615384615385 }, { "name": "Heidi", "popularity": 1.707070707070707 }, { "name": "Olive", "popularity": 1.6730769230769231 }, { "name": "Shelley", "popularity": 1.6629213483146068 }, { "name": "Kelli", "popularity": 1.6545454545454545 }, { "name": "Colleen", "popularity": 1.6453900709219857 }, { "name": "Kristine", "popularity": 1.5 }, { "name": "Teri", "popularity": 1.3880597014925373 }, { "name": "Pat", "popularity": 1.2592592592592593 }, { "name": "Tamara", "popularity": 1.2342342342342343 }, { "name": "Gayle", "popularity": 1.1375 }, { "name": "Julie", "popularity": 1.1333333333333333 }, { "name": "Deanna", "popularity": 1.1214953271028036 } ] }, { "gender": "M", "by_name": [ { "name": "Kelly", "popularity": 2.236111111111111 }, { "name": "Woodrow", "popularity": 2.1923076923076925 }, { "name": "Rick", "popularity": 2.04 }, { "name": "Dave", "popularity": 2 }, { "name": "Bob", "popularity": 1.9285714285714286 }, { "name": "Jim", "popularity": 1.8488372093023255 }, { "name": "Dan", "popularity": 1.7652173913043478 }, { "name": "Jason", "popularity": 1.6666666666666667 }, { "name": "Jeff", "popularity": 1.6225165562913908 }, { "name": "Mike", "popularity": 1.5695652173913044 }, { "name": "Brad", "popularity": 1.3717948717948718 }, { "name": "Gordon", "popularity": 1.355421686746988 }, { "name": "Greg", "popularity": 1.3545454545454545 }, { "name": "Bill", "popularity": 1.2804232804232805 }, { "name": "Jon", "popularity": 1.2137931034482758 } ] } ] }, { "state": "WI", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Kristine", "popularity": 2.8295454545454546 }, { "name": "Laverne", "popularity": 2.4545454545454546 }, { "name": "Jodi", "popularity": 1.7840909090909092 }, { "name": "Marcella", "popularity": 1.7258064516129032 }, { "name": "Kristin", "popularity": 1.328358208955224 }, { "name": "Lynn", "popularity": 1.3274336283185841 }, { "name": "Sophie", "popularity": 1.278688524590164 }, { "name": "Kay", "popularity": 1.2231404958677685 }, { "name": "Julie", "popularity": 1.1573333333333333 }, { "name": "Jody", "popularity": 1.1343283582089552 }, { "name": "Lorraine", "popularity": 1.0772357723577235 }, { "name": "Violet", "popularity": 1.0566037735849056 }, { "name": "Jill", "popularity": 1.0336538461538463 }, { "name": "Arlene", "popularity": 1.0123456790123457 }, { "name": "Audrey", "popularity": 0.946236559139785 } ] }, { "gender": "M", "by_name": [ { "name": "Jerome", "popularity": 2.1073825503355703 }, { "name": "Lyle", "popularity": 2.0317460317460316 }, { "name": "Todd", "popularity": 1.8065693430656935 }, { "name": "Duane", "popularity": 1.6370967741935485 }, { "name": "Dean", "popularity": 1.3846153846153846 }, { "name": "Kurt", "popularity": 1.3837209302325582 }, { "name": "Gordon", "popularity": 1.216867469879518 }, { "name": "Dale", "popularity": 1.1525974025974026 }, { "name": "Jon", "popularity": 1.1310344827586207 }, { "name": "Allan", "popularity": 1.1294117647058823 }, { "name": "Gerald", "popularity": 1.089795918367347 }, { "name": "Scott", "popularity": 1.077798861480076 }, { "name": "Arnold", "popularity": 0.9196428571428571 }, { "name": "Gregg", "popularity": 0.8823529411764706 }, { "name": "Jeffrey", "popularity": 0.8058479532163743 } ] } ] }, { "state": "WV", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Patty", "popularity": 2.2409638554216866 }, { "name": "Opal", "popularity": 1.9690721649484537 }, { "name": "Dianna", "popularity": 1.7794117647058822 }, { "name": "Beulah", "popularity": 1.7790697674418605 }, { "name": "Violet", "popularity": 1.7735849056603774 }, { "name": "Mabel", "popularity": 1.6764705882352942 }, { "name": "Naomi", "popularity": 1.6071428571428572 }, { "name": "Nellie", "popularity": 1.4809160305343512 }, { "name": "Della", "popularity": 1.3859649122807018 }, { "name": "Tammy", "popularity": 1.3540489642184557 }, { "name": "Wilma", "popularity": 1.339080459770115 }, { "name": "Sherri", "popularity": 1.1507936507936507 }, { "name": "Nina", "popularity": 1.1375 }, { "name": "Thelma", "popularity": 1.1216730038022813 }, { "name": "Maxine", "popularity": 1.053030303030303 } ] }, { "gender": "M", "by_name": [ { "name": "Jackie", "popularity": 2.606382978723404 }, { "name": "Delbert", "popularity": 2.2 }, { "name": "Homer", "popularity": 2.0428571428571427 }, { "name": "Franklin", "popularity": 2 }, { "name": "Woodrow", "popularity": 1.6538461538461537 }, { "name": "Cecil", "popularity": 1.6521739130434783 }, { "name": "Virgil", "popularity": 1.5897435897435896 }, { "name": "Willard", "popularity": 1.423529411764706 }, { "name": "Everett", "popularity": 1.2820512820512822 }, { "name": "Dana", "popularity": 1.2592592592592593 }, { "name": "Clyde", "popularity": 1.185430463576159 }, { "name": "Roger", "popularity": 1.1063829787234043 }, { "name": "Danny", "popularity": 1.0357142857142858 }, { "name": "Luther", "popularity": 1.0149253731343284 }, { "name": "Lewis", "popularity": 1.0069444444444444 } ] } ] }, { "state": "WY", "by_gender": [ { "gender": "F", "by_name": [ { "name": "Pat", "popularity": 3.074074074074074 }, { "name": "Shannon", "popularity": 2.8941176470588235 }, { "name": "Becky", "popularity": 2.7981651376146788 }, { "name": "Shelley", "popularity": 2.550561797752809 }, { "name": "Natalie", "popularity": 2.4833333333333334 }, { "name": "Jody", "popularity": 2.417910447761194 }, { "name": "Jamie", "popularity": 2.3661971830985915 }, { "name": "Stacy", "popularity": 2.313131313131313 }, { "name": "Agnes", "popularity": 2.2885906040268456 }, { "name": "Shelly", "popularity": 2.1333333333333333 }, { "name": "Violet", "popularity": 2.0943396226415096 }, { "name": "Olive", "popularity": 2 }, { "name": "Laurie", "popularity": 1.9820627802690582 }, { "name": "Hazel", "popularity": 1.974025974025974 }, { "name": "Opal", "popularity": 1.9278350515463918 } ] }, { "gender": "M", "by_name": [ { "name": "Troy", "popularity": 5.940740740740741 }, { "name": "Jason", "popularity": 4.430555555555555 }, { "name": "Kelly", "popularity": 3.75 }, { "name": "Kim", "popularity": 3.5517241379310347 }, { "name": "Brad", "popularity": 3.1923076923076925 }, { "name": "Kent", "popularity": 2.9014084507042255 }, { "name": "Woodrow", "popularity": 2.5961538461538463 }, { "name": "Brett", "popularity": 2.547945205479452 }, { "name": "Lance", "popularity": 2.5357142857142856 }, { "name": "Bob", "popularity": 2.2767857142857144 }, { "name": "Darin", "popularity": 2.0377358490566038 }, { "name": "Jim", "popularity": 1.9593023255813953 }, { "name": "Bill", "popularity": 1.693121693121693 }, { "name": "Darren", "popularity": 1.6701030927835052 }, { "name": "Bradley", "popularity": 1.6585365853658536 } ] } ] } ]
WITH __stage0 AS ( SELECT group_set, (floor(base.year/10))*10 as decade__0, base.state as state__0, CASE WHEN base.gender='M' THEN 'Male' ELSE 'Female' END as baby_gender__0, base.gender as gender__0, CASE WHEN group_set=0 THEN COALESCE(SUM(base.number),0) END as cohort_population__0, CASE WHEN group_set=1 THEN base.name END as name__1, CASE WHEN group_set=1 THEN COALESCE(SUM(base.number),0) END as population__1 FROM `bigquery-public-data.usa_names.usa_1910_current` as base CROSS JOIN (SELECT row_number() OVER() -1 group_set FROM UNNEST(GENERATE_ARRAY(0,1,1))) GROUP BY 1,2,3,4,5,7 ) , __stage1 AS ( SELECT decade__0 as decade, state__0 as state, baby_gender__0 as baby_gender, gender__0 as gender, ANY_VALUE(CASE WHEN group_set=0 THEN cohort_population__0 END) as cohort_population, ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT( name__1 as name, population__1 as population ) END IGNORE NULLS ORDER BY population__1 desc ) as by_name FROM __stage0 GROUP BY 1,2,3,4 ORDER BY 5 desc ) , __stage2 AS ( SELECT group_set, concat(by_name_0.name,'') as name__0, names.gender as gender__0, floor((CASE WHEN group_set=0 THEN COALESCE(SUM(by_name_0.population),0) END/CASE WHEN group_set=0 THEN COALESCE(CAST(( ( SUM(DISTINCT (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) + (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001 )) - SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001) )/(1*1.0)) as FLOAT64),0) END)*100000) as births_per_100k__0, CASE WHEN group_set=1 THEN names.state END as state__1, floor((CASE WHEN group_set=1 THEN COALESCE(SUM(by_name_0.population),0) END/CASE WHEN group_set=1 THEN COALESCE(CAST(( ( SUM(DISTINCT (CAST(ROUND(COALESCE(names.cohort_population,0)*(1*1.0), 9) AS NUMERIC) + (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001 )) - SUM(DISTINCT (cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 1, 15)) as int64) as numeric) * 4294967296 + cast(cast(concat('0x', substr(to_hex(md5(CAST(names.__distinct_key AS STRING))), 16, 8)) as int64) as numeric)) * 0.000000001) )/(1*1.0)) as FLOAT64),0) END)*100000) as births_per_100k__1 FROM (SELECT GENERATE_UUID() as __distinct_key, * FROM __stage1 as x) as names LEFT JOIN UNNEST(names.by_name) as by_name_0 CROSS JOIN (SELECT row_number() OVER() -1 group_set FROM UNNEST(GENERATE_ARRAY(0,1,1))) WHERE names.decade<1970 GROUP BY 1,2,3,5 ) , __stage3 AS ( SELECT name__0 as name, gender__0 as gender, ANY_VALUE(CASE WHEN group_set=0 THEN births_per_100k__0 END) as births_per_100k, ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT( state__1 as state, births_per_100k__1 as births_per_100k ) END IGNORE NULLS ORDER BY births_per_100k__1 desc ) as by_state FROM __stage2 GROUP BY 1,2 ORDER BY 3 desc ) , __stage4 AS ( SELECT group_set, by_state_0.state as state__0, CASE WHEN group_set IN (1,2) THEN base.gender END as gender__1, CASE WHEN group_set=2 THEN base.name END as name__2, CASE WHEN group_set=2 THEN ((by_state_0.births_per_100k-base.births_per_100k))/base.births_per_100k END as popularity__2 FROM __stage3 as base LEFT JOIN UNNEST(base.by_state) as by_state_0 CROSS JOIN (SELECT row_number() OVER() -1 group_set FROM UNNEST(GENERATE_ARRAY(0,2,1))) WHERE base.births_per_100k>50 GROUP BY 1,2,3,4,5 ) , __stage5 AS ( SELECT CASE WHEN group_set=2 THEN 1 ELSE group_set END as group_set, state__0 as state__0, CASE WHEN group_set IN (1,2) THEN gender__1 END as gender__1, ARRAY_AGG(CASE WHEN group_set=2 THEN STRUCT( name__2 as name, popularity__2 as popularity ) END IGNORE NULLS ORDER BY popularity__2 desc LIMIT 15) as by_name__1 FROM __stage4 GROUP BY 1,2,3 ) SELECT state__0 as state, ARRAY_AGG(CASE WHEN group_set=1 THEN STRUCT( gender__1 as gender, by_name__1 as by_name ) END IGNORE NULLS ORDER BY gender__1 asc ) as by_gender FROM __stage5 GROUP BY 1 ORDER BY 1 asc
Malloy